DBA Data[Home] [Help]

APPS.PER_PERUSEOC_XMLP_PKG dependencies on PER_PEOPLE_F

Line 360: PER_PEOPLE_F PEO1

356: AND PEO.EFFECTIVE_START_DATE = (
357: SELECT
358: MAX(PEO1.EFFECTIVE_START_DATE)
359: FROM
360: PER_PEOPLE_F PEO1
361: WHERE P_PAYROLL_PERIOD_DATE_START_T <= PEO1.EFFECTIVE_END_DATE
362: AND P_PAYROLL_PERIOD_DATE_END_T >= PEO1.EFFECTIVE_START_DATE
363: AND PEO.PERSON_ID = PEO1.PERSON_ID
364: AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y' )