DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 178: PAY_ELEMENT_CLASSIFICATIONS PEC

174: WHERE PEEF.ASSIGNMENT_ID = P_ASSIGNMENT_ID
175: AND PEEF.ELEMENT_TYPE_ID IN
176: ( SELECT DISTINCT ELEMENT_TYPE_ID
177: FROM pay_sub_classification_rules_f PSCR ,
178: PAY_ELEMENT_CLASSIFICATIONS PEC
179: WHERE PSCR.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID
180: AND PEC.CLASSIFICATION_NAME = 'Pension Qualifying Earnings'
181: AND P_DATE_EARNED BETWEEN PSCR.EFFECTIVE_START_DATE AND PSCR.EFFECTIVE_END_DATE
182: )