DBA Data[Home] [Help]

APPS.PER_PERUSEOC_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 348: PER_ALL_PEOPLE_F PEO,

344: LOC.LOCATION_CODE,
345: JOB.NAME JOB_NAME,
346: ASS.JOB_ID
347: FROM
348: PER_ALL_PEOPLE_F PEO,
349: PER_ASSIGNMENTS_F ASS,
350: --PER_JOBS_VL JOB, - Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
351: PER_JOBS JOB,
352: HR_LOCATIONS_ALL LOC

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

366: AND PEO.EFFECTIVE_START_DATE = (
367: SELECT
368: MAX(PEO1.EFFECTIVE_START_DATE)
369: FROM
370: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F
371: PER_ALL_PEOPLE_F PEO1
372: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
373: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
374: AND PEO.PERSON_ID = PEO1.PERSON_ID

Line 371: PER_ALL_PEOPLE_F PEO1

367: SELECT
368: MAX(PEO1.EFFECTIVE_START_DATE)
369: FROM
370: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F
371: PER_ALL_PEOPLE_F PEO1
372: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
373: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
374: AND PEO.PERSON_ID = PEO1.PERSON_ID
375: AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y' )