DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1075: PAY_ELEMENT_CLASSIFICATIONS PEC

1071: WHERE PEEF.ASSIGNMENT_ID = P_ASSIGNMENT_ID
1072: AND PEEF.ELEMENT_TYPE_ID IN
1073: ( SELECT DISTINCT ELEMENT_TYPE_ID
1074: FROM pay_element_types_f petf ,
1075: PAY_ELEMENT_CLASSIFICATIONS PEC
1076: WHERE Petf.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID
1077: AND PEC.CLASSIFICATION_NAME = 'Information'
1078: AND PETF.ELEMENT_NAME NOT IN ('NI','PAYE')
1079: AND P_EFFECTIVE_DATE BETWEEN petf.EFFECTIVE_START_DATE AND petf.EFFECTIVE_END_DATE

Line 1096: PAY_ELEMENT_CLASSIFICATIONS PEC

1092: AND P_EFFECTIVE_DATE BETWEEN pivf.EFFECTIVE_START_DATE AND pivf.EFFECTIVE_END_DATE
1093: AND frr.ELEMENT_TYPE_ID IN
1094: ( SELECT DISTINCT ELEMENT_TYPE_ID
1095: FROM pay_sub_classification_rules_f PSCR ,
1096: PAY_ELEMENT_CLASSIFICATIONS PEC
1097: WHERE PSCR.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID
1098: AND PEC.CLASSIFICATION_NAME = 'Pension Qualifying Earnings'
1099: AND P_EFFECTIVE_DATE BETWEEN PSCR.EFFECTIVE_START_DATE AND PSCR.EFFECTIVE_END_DATE
1100: )