APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 318: PER_ALL_PEOPLE_F PEO,

314: COUNT(PEO.PERSON_ID)
315: INTO L_COUNT_EMPS
316: FROM
317: PER_ALL_ASSIGNMENTS_F ASS,
318: PER_ALL_PEOPLE_F PEO,
319: PER_JOBS_VL JOB
320: WHERE PEO.PERSON_ID = ASS.PERSON_ID
321: AND PEO.PER_INFORMATION1 is not NULL
322: AND JOB.JOB_INFORMATION_CATEGORY = 'US'

Line 491: PER_ALL_PEOPLE_F PEO,

487: ,1
488: ,NULL))
489: INTO CP_HW_CAT,CP_HW_MALE,CP_HW_FEMALE
490: FROM
491: PER_ALL_PEOPLE_F PEO,
492: PER_ALL_ASSIGNMENTS_F ASS,
493: PER_JOBS_VL JOB
494: WHERE PEO.PERSON_ID = ASS.PERSON_ID
495: AND PEO.PER_INFORMATION1 is not NULL

Line 509: PER_ALL_PEOPLE_F PEO1

505: AND PEO.EFFECTIVE_START_DATE = (
506: SELECT
507: MAX(PEO1.EFFECTIVE_START_DATE)
508: FROM
509: PER_ALL_PEOPLE_F PEO1
510: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
511: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
512: AND PEO.PERSON_ID = PEO1.PERSON_ID
513: AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y' )

Line 608: PER_ALL_PEOPLE_F PEO,

604: COUNT('ass')
605: INTO L_COUNT_EMPS
606: FROM
607: PER_ALL_ASSIGNMENTS_F ASS,
608: PER_ALL_PEOPLE_F PEO,
609: PER_JOBS_VL JOB
610: WHERE PEO.PERSON_ID = ASS.PERSON_ID
611: AND PEO.PER_INFORMATION1 is not NULL
612: AND JOB.JOB_INFORMATION_CATEGORY = 'US'

Line 854: PER_ALL_PEOPLE_F PEO,

850: HL.LOCATION_CODE,
851: JOB.NAME JOB_NAME,
852: ASS.JOB_ID
853: FROM
854: PER_ALL_PEOPLE_F PEO,
855: PER_ALL_ASSIGNMENTS_F ASS,
856: PER_JOBS_VL JOB,
857: HR_LOCATIONS_ALL HL
858: WHERE PEO.PERSON_ID = ASS.PERSON_ID