DBA Data[Home] [Help]

APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_PEOPLE_F

Line 332: PER_PEOPLE_F PEO1

328: AND PEO.EFFECTIVE_START_DATE = (
329: SELECT
330: MAX(PEO1.EFFECTIVE_START_DATE)
331: FROM
332: PER_PEOPLE_F PEO1
333: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
334: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
335: AND PEO.PERSON_ID = PEO1.PERSON_ID
336: AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y' )

Line 871: PER_PEOPLE_F PEO1

867: AND PEO.EFFECTIVE_START_DATE = (
868: SELECT
869: MAX(PEO1.EFFECTIVE_START_DATE)
870: FROM
871: PER_PEOPLE_F PEO1
872: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
873: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
874: AND PEO.PERSON_ID = PEO1.PERSON_ID
875: AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y' )