DBA Data[Home] [Help]

APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 880: PER_ASSIGNMENTS_F ASS1

876: AND ASS.EFFECTIVE_START_DATE = (
877: SELECT
878: MAX(ASS1.EFFECTIVE_START_DATE)
879: FROM
880: PER_ASSIGNMENTS_F ASS1
881: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
882: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
883: AND ASS.PERSON_ID = ASS1.PERSON_ID
884: AND ASS1.ASSIGNMENT_TYPE = 'E'