DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 1095: FROM pay_sub_classification_rules_f PSCR ,

1091: AND P_EFFECTIVE_DATE BETWEEN frr.EFFECTIVE_START_DATE AND frr.EFFECTIVE_END_DATE
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