APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

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

506: SELECT
507: MAX(ASS1.EFFECTIVE_START_DATE)
508: FROM
509: PER_ALL_ASSIGNMENTS_F ASS1,
510: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
511: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
512: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
513: AND ASS.PERSON_ID = ASS1.PERSON_ID
514: AND ASS1.ASSIGNMENT_TYPE = 'E'

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

769: SELECT
770: MAX(ASS1.EFFECTIVE_START_DATE)
771: FROM
772: PER_ALL_ASSIGNMENTS_F ASS1,
773: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
774: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
775: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
776: AND ASS.PERSON_ID = ASS1.PERSON_ID
777: AND ASS1.ASSIGNMENT_TYPE = 'E'

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

953: SELECT
954: MAX(ASS1.EFFECTIVE_START_DATE)
955: FROM
956: PER_ALL_ASSIGNMENTS_F ASS1,
957: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
958: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
959: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
960: AND ASS.PERSON_ID = ASS1.PERSON_ID
961: AND ASS1.ASSIGNMENT_TYPE = 'E'

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

1270: MAX(ASS1.EFFECTIVE_START_DATE)
1271: FROM
1272: --PER_ASSIGNMENTS_F ASS1 - Replaced PER_ASSIGNMENTS_F with PER_ALL_ASSIGNMENTS_F
1273: PER_ALL_ASSIGNMENTS_F ASS1,
1274: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
1275: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
1276: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
1277: AND ASS.PERSON_ID = ASS1.PERSON_ID
1278: AND ASS1.ASSIGNMENT_TYPE = 'E'