Oracle Fusion HCM Knowledge Hub

SELECT PGLFT.NAME         FROM FUSION.PER_PERSON_NAMES_F     PPNF,              FUSION.PER_ALL_ASSIGNMENTS_M  PAAM,              FUSION.PER_GRADE_LADDERS_F_TL PGLFT,              FUSION.PER_GRADE_LADDERS_F    PGLF        WHERE PPNF.PERSON_ID = PAAM.PERSON_ID          AND PAAM.GRADE_LADDER_PGM_ID(+) = PGLFT.GRADE_LADDER_ID          AND PPNF.PERSON_ID = PAAM.PERSON_ID          AND PPNF.NAME_TYPE = 'GLOBAL'          AND PAAM.ASSIGNMENT_TYPE = 'E'          AND PAAM.PERSON_ID = P_PERSON_ID          AND PGLFT.LANGUAGE = USERENV('LANG')          AND PGLFT.GRADE_LADDER_ID = PGLF.GRADE_LADDER_ID          AND TRUNC(SYSDATE) BETW...

SELECT PPNF.FULL_NAME       FROM FUSION.PER_PERSON_NAMES_F    PPNF,            FUSION.PER_ALL_PEOPLE_F      PAPF,            FUSION.PER_ALL_ASSIGNMENTS_M PAAM      WHERE PPNF.PERSON_ID = PAPF.PERSON_ID        AND PAPF.PERSON_ID = PAAM.PERSON_ID        AND PAAM.PERSON_ID = PPNF.PERSON_ID        AND PPNF.NAME_TYPE = 'GLOBAL'        AND PAAM.JOB_ID = P_JOB_ID        AND PAAM.ASSIGNMENT_TYPE = 'E'        AND PAAM.POSITION_ID = P_POSITION_ID        AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND            PAAM.EFFECTIVE_END_DATE        AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND            PPNF.EFFECTIVE_END_DATE        ...

SELECT FLT.MEANING, FLB.TAG, FLT.DESCRIPTION      FROM FUSION.FND_LOOKUP_VALUES_TL FLT,                   FUSION.FND_LOOKUP_VALUES_B FLB      WHERE FLB.LOOKUP_TYPE = FLT.LOOKUP_TYPE        AND FLT.LOOKUP_CODE = FLB.LOOKUP_CODE        AND FLB.ENABLED_FLAG = 'Y'        AND FLT.LANGUAGE = USERENV('LANG')        AND FLB.LOOKUP_CODE = P_LOOKUP_CODE        AND FLB.LOOKUP_TYPE = P_LOOKUP_TYPE;

SELECT parb.action_reason_code       FROM fusion.per_all_people_f       papf,            fusion.per_periods_of_service ppos,            ---------------------------------------            fusion.per_all_assignments_m paam,            ---------------------------------------            fusion.PER_ACTION_OCCURRENCES pao,            fusion.PER_ACTION_REASONS_B   parb,            fusion.per_action_reasons_tl  PART             ---------------------------------------         WHERE 1 = 1        AND TRUNC(P_DATE) BETWEEN papf.effective_start_date AND            papf.effective_end_date        AND papf.pers...

SELECT PPTL.USER_PERSON_TYPE           FROM FUSION.PER_PERSON_TYPE_USAGES_M PPTUM,            FUSION.PER_PERSON_NAMES_F       PPNF,            FUSION.PER_PERSON_TYPES_TL      PPTL      WHERE PPTUM.PERSON_ID = PPNF.PERSON_ID        AND PPTL.PERSON_TYPE_ID = PPTUM.PERSON_TYPE_ID        AND PPTL.LANGUAGE = USERENV('LANG')        AND PPNF.PERSON_ID = P_PERSON_ID        AND PPNF.NAME_TYPE = 'GLOBAL'        AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND            PPNF.EFFECTIVE_END_DATE        AND TRUNC(SYSDATE) BETWEEN PPTUM.EFFECTIVE_START_DATE AND            PPTUM.EFFECTIVE_END_DATE;

SELECT PPNF.DISPLAY_NAME            FROM FUSION.PER_ASSIGNMENT_SUPERVISORS_F PASF,            FUSION.PER_PERSON_NAMES_F           PPNF      WHERE PASF.PERSON_ID = P_PERSON_ID        AND PPNF.PERSON_ID = PASF.MANAGER_ID        AND SYSDATE BETWEEN PASF.EFFECTIVE_START_DATE AND            PASF.EFFECTIVE_END_DATE        AND SYSDATE BETWEEN PPNF.EFFECTIVE_START_DATE AND            PPNF.EFFECTIVE_END_DATE        AND PPNF.NAME_TYPE = 'GLOBAL';

SELECT PAPF1.FULL_NAME         FROM FUSION.PER_PERSON_NAMES_F            PAPF1,            FUSION.HR_ORGANIZATION_INFORMATION_F HOIF      WHERE PAPF1.PERSON_ID = HOIF.ORG_INFORMATION2        AND HOIF.ORGANIZATION_ID = P_ORG_ID        AND HOIF.ORG_INFORMATION_CONTEXT = 'PER_ORG_MANAGER_INFO'        AND PAPF1.NAME_TYPE = 'GLOBAL'        AND P_EFFECTIVE_DATE BETWEEN PAPF1.EFFECTIVE_START_DATE AND            PAPF1.EFFECTIVE_END_DATE        AND P_EFFECTIVE_DATE BETWEEN HOIF.EFFECTIVE_START_DATE AND            HOIF.EFFECTIVE_END_DATE;

select PGSFL.Name       FROM FUSION.PER_ALL_PEOPLE_F         PAPF,            FUSION.PER_PERSON_NAMES_F       PPNF,            FUSION.PER_ALL_ASSIGNMENTS_M    PAAM,            FUSION.PER_GRADES_F             PGF,            FUSION.PER_GRADE_STEPS_F_TL     PGSFL,            FUSION.Per_Assign_Grade_Steps_f  PAGSF      where paam.assignment_status_type = 'ACTIVE'        AND PAAM.PRIMARY_FLAG = 'Y'        AND PGSFL.LANGUAGE = USERENV('LANG')        AND PPNF.NAME_TYPE = 'GLOBAL'        AND PAAM.PERSON_ID = PAPF.PERSON_ID        AND PAAM.GRADE_ID = PGF.GRADE_ID        AND PPNF...

 SELECT NATIONAL_IDENTIFIER_NUMBER      FROM FUSION.PER_NATIONAL_IDENTIFIERS PNI,            FUSION.PER_ALL_PEOPLE_F         PAPF      WHERE PAPF.PERSON_ID = PNI.PERSON_ID        AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND            PAPF.EFFECTIVE_END_DATE        AND PAPF.PERSON_NUMBER = P_PERSON_NUMBER

select sum(D.RESULT_VALUE)          from FUSION.PAY_PAYROLL_ACTIONS      a,            FUSION.PAY_PAYROLL_REL_ACTIONS  b,            FUSION.pay_run_results          c,            FUSION.PAY_RUN_RESULT_VALUES    D,            FUSION.PAY_PAY_RELATIONSHIPS_Dn e,            FUSION.PER_person_names_f       f,            FUSION.pay_element_types_vl     g,            FUSION.PAY_TIME_PERIODS         h      where a.LEGISLATIVE_DATA_GROUP_ID IN            (SELECT LEGISLATIVE_DATA_GROUP_ID               FROM FUSION.PER_LEGISLATIVE_DATA_GROUPS_VL     ...

SELECT round(prvf.value, 2)             FROM fusion.per_rates_f              prf,            fusion.per_rate_values_f        prvf,            fusion.per_assign_grade_steps_f pagsf,            fusion.per_all_assignments_m    paam      WHERE prf.rate_id = prvf.rate_id        AND prf.rate_object_type = 'STEP'        AND prf.grade_ladder_id = paam.grade_ladder_pgm_id        AND TRUNC(P_DATE) BETWEEN prf.effective_start_date AND            prf.effective_end_date        AND prvf.rate_object_type = 'STEP'        AND TRUNC(P_DATE) BETWEEN prvf.effective_start_date AND            prvf.effective_end_date       ...

SELECT PGFT.NAME           FROM FUSION.PER_ALL_PEOPLE_F      PAPF,            FUSION.PER_ALL_ASSIGNMENTS_M PAAM,            FUSION.PER_GRADES_F_TL       PGFT      WHERE 1 = 1        AND PAPF.PERSON_ID = PAAM.PERSON_ID        AND PAAM.GRADE_ID = PGFT.GRADE_ID        AND PGFT.LANGUAGE = USERENV('LANG')        AND PAAM.ASSIGNMENT_TYPE = 'E'        AND PAAM.Assignment_Status_Type = 'ACTIVE'        AND PAPF.PERSON_NUMBER = P_PERSON_NUMBER        AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND            PAPF.EFFECTIVE_END_DATE        AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND            PAAM.EFFECTIVE_END_...

SELECT PJFT.NAME       FROM FUSION.PER_ALL_PEOPLE_F      PAPF,            FUSION.PER_ALL_ASSIGNMENTS_M PAAM,            FUSION.PER_JOBS_F_TL         PJFT      WHERE 1 = 1        AND PAPF.PERSON_ID = PAAM.PERSON_ID        AND PAAM.JOB_ID = PJFT.JOB_ID        AND PJFT.LANGUAGE = USERENV('LANG')        AND PAAM.ASSIGNMENT_TYPE = 'E'        AND PAAM.Assignment_Status_Type = 'ACTIVE'        AND PAPF.PERSON_NUMBER = P_PERSON_NUMBER        AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND            PAPF.EFFECTIVE_END_DATE        AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND            PAAM.EFFECTIVE_END_DATE   ...

SELECT PPLF.SEX               FROM FUSION.PER_PERSON_NAMES_F       PAPF,              FUSION.PER_PEOPLE_LEGISLATIVE_F PPLF        WHERE PPLF.PERSON_ID(+) = PAPF.PERSON_ID          AND PAPF.NAME_TYPE = 'GLOBAL'          AND PAPF.PERSON_NUMBER = P_PERSON_NUMBER          AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND              PAPF.EFFECTIVE_END_DATE          AND TRUNC(SYSDATE) BETWEEN PPLF.EFFECTIVE_START_DATE AND              PPLF.EFFECTIVE_END_DATE;

SELECT HOUFT.NAME            FROM FUSION.HR_ORGANIZATION_UNITS_F_TL HOUFT      WHERE HOUFT.ORGANIZATION_ID = &P_ORG_ID        AND HOUFT.LANGUAGE = USERENV('LANG')        AND TRUNC(SYSDATE) BETWEEN HOUFT.EFFECTIVE_START_DATE AND            HOUFT.EFFECTIVE_END_DATE;

SELECT PPNF.FULL_NAME      FROM FUSION.PER_PERSON_NAMES_F    PPNF,            FUSION.PER_ALL_PEOPLE_F      PAPF,            FUSION.PER_ALL_ASSIGNMENTS_M PAAM      WHERE PPNF.PERSON_ID = PAPF.PERSON_ID        AND PAPF.PERSON_ID = PAAM.PERSON_ID        AND PAAM.PERSON_ID = PPNF.PERSON_ID        AND PPNF.NAME_TYPE = 'GLOBAL'        AND PAAM.JOB_ID = P_JOB_ID        AND PAAM.ASSIGNMENT_TYPE = 'E'        AND PAAM.POSITION_ID = &P_POSITION_ID        AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND            PAAM.EFFECTIVE_END_DATE        AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND            PPNF.EFFECTIVE_END_DATE   ...