APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 480: FROM PER_ALL_PEOPLE_F PEO,

476: L_COUNT_EMPS NUMBER := 0;
477: BEGIN
478: SELECT COUNT(PEO.PERSON_ID)
479: INTO L_COUNT_EMPS
480: FROM PER_ALL_PEOPLE_F PEO,
481: PER_ALL_ASSIGNMENTS_F ASS,
482: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL with PER_JOBS - bug#11736960
483: PER_JOBS JOB
484: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 499: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F -bug#11736960

495: AND PEO.EFFECTIVE_START_DATE = (
496: SELECT
497: MAX(PEO1.EFFECTIVE_START_DATE)
498: FROM
499: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F -bug#11736960
500: PER_ALL_PEOPLE_F PEO1
501: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
502: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
503: AND PEO.PERSON_ID = PEO1.PERSON_ID

Line 500: PER_ALL_PEOPLE_F PEO1

496: SELECT
497: MAX(PEO1.EFFECTIVE_START_DATE)
498: FROM
499: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F -bug#11736960
500: PER_ALL_PEOPLE_F PEO1
501: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
502: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
503: AND PEO.PERSON_ID = PEO1.PERSON_ID
504: AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y' )

Line 740: PER_ALL_PEOPLE_F PEO,

736: ,1
737: ,NULL))
738: INTO CP_HW_CAT,CP_HW_MALE,CP_HW_FEMALE
739: FROM
740: PER_ALL_PEOPLE_F PEO,
741: PER_ALL_ASSIGNMENTS_F ASS,
742: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL with PER_JOBS - bug#11736960
743: PER_JOBS JOB
744: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 763: PER_ALL_PEOPLE_F PEO1

759: AND PEO.EFFECTIVE_START_DATE = (
760: SELECT
761: MAX(PEO1.EFFECTIVE_START_DATE)
762: FROM
763: PER_ALL_PEOPLE_F PEO1
764: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
765: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
766: AND PEO.PERSON_ID = PEO1.PERSON_ID
767: AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y' )

Line 918: PER_ALL_PEOPLE_F PEO,

914: COUNT('X')
915: INTO L_COUNT_EMPS
916: FROM
917: PER_ALL_ASSIGNMENTS_F ASS,
918: PER_ALL_PEOPLE_F PEO,
919: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL wth PER_JOBS - bug#11736960
920: PER_JOBS JOB
921: WHERE PEO.PERSON_ID = ASS.PERSON_ID
922: --

Line 941: FROM PER_ALL_PEOPLE_F PEO1

937: AND PEO.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
938: AND JOB.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
939: AND PEO.EFFECTIVE_START_DATE =
940: (SELECT MAX(PEO1.EFFECTIVE_START_DATE)
941: FROM PER_ALL_PEOPLE_F PEO1
942: WHERE P_PAYROLL_PERIOD_DATE_START_T
943: <= PEO1.EFFECTIVE_END_DATE
944: AND P_PAYROLL_PERIOD_DATE_END_T
945: >= PEO1.EFFECTIVE_START_DATE

Line 1240: PER_ALL_PEOPLE_F PEO,

1236: HL.LOCATION_CODE,
1237: JOB.NAME JOB_NAME,
1238: ASS.JOB_ID
1239: FROM
1240: PER_ALL_PEOPLE_F PEO,
1241: PER_ALL_ASSIGNMENTS_F ASS,
1242: --PER_JOBS_VL JOB, - Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
1243: PER_JOBS JOB,
1244: HR_LOCATIONS_ALL HL

Line 1262: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F

1258: AND PEO.EFFECTIVE_START_DATE = (
1259: SELECT
1260: MAX(PEO1.EFFECTIVE_START_DATE)
1261: FROM
1262: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F
1263: PER_ALL_PEOPLE_F PEO1
1264: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
1265: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
1266: AND PEO.PERSON_ID = PEO1.PERSON_ID

Line 1263: PER_ALL_PEOPLE_F PEO1

1259: SELECT
1260: MAX(PEO1.EFFECTIVE_START_DATE)
1261: FROM
1262: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F
1263: PER_ALL_PEOPLE_F PEO1
1264: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
1265: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
1266: AND PEO.PERSON_ID = PEO1.PERSON_ID
1267: AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y' )