DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 200: FROM PAY_STATUS_PROCESSING_RULES_F PSPF

196: --Fetch formula, if any, attached to the element
197: CURSOR C_PENSIONS_FORMULA_ID(P_ELEMENT_TYPE_ID VARCHAR2,P_EFFECTIVE_DATE DATE)
198: IS
199: SELECT PSPF.FORMULA_ID, PSPF.STATUS_PROCESSING_RULE_ID
200: FROM PAY_STATUS_PROCESSING_RULES_F PSPF
201: WHERE PSPF.ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID
202: AND PSPF.ASSIGNMENT_STATUS_TYPE_ID is NULL
203: AND P_EFFECTIVE_DATE BETWEEN PSPF.EFFECTIVE_START_DATE AND PSPF.EFFECTIVE_END_DATE;
204: --Fetch Screen Entry value for an input value