APPS.PER_PERUSEOC_XMLP_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 381: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720

377: SELECT
378: MAX(ASS1.EFFECTIVE_START_DATE)
379: FROM
380: PER_ASSIGNMENTS_F ASS1,
381: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
382: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
383: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
384: AND ASS.PERSON_ID = ASS1.PERSON_ID
385: AND ASS1.ASSIGNMENT_TYPE = 'E'