DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_ELEMENT_ENTRIES_F

Line 173: FROM PAY_ELEMENT_ENTRIES_F PEEF

169: CURSOR C_ELEMENT_DETAILS(P_DATE_EARNED DATE , P_ASSIGNMENT_ID NUMBER, P_ELEMENT_TYPE_ID NUMBER)
170: IS
171: SELECT PEEF.ELEMENT_ENTRY_ID,
172: PEEF.ELEMENT_TYPE_ID
173: FROM PAY_ELEMENT_ENTRIES_F PEEF
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 ,