APPS.PAY_PAYGBTPL_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 16: PAY_ELEMENT_TYPES_F PET

12: PET.ELEMENT_TYPE_ID
13: FROM
14: PAY_INPUT_VALUES_F PIV_SCON,
15: PAY_INPUT_VALUES_F PIV_CAT,
16: PAY_ELEMENT_TYPES_F PET
17: WHERE PET.ELEMENT_NAME = 'NI'
18: AND PET.LEGISLATION_CODE = 'GB'
19: AND PIV_SCON.NAME = 'SCON'
20: AND PET.LEGISLATION_CODE = PIV_SCON.LEGISLATION_CODE

Line 175: PAY_ELEMENT_TYPES_F

171: CURSOR CSR_PAYE_ELEMENT IS
172: SELECT
173: ELEMENT_TYPE_ID
174: FROM
175: PAY_ELEMENT_TYPES_F
176: WHERE ELEMENT_NAME = 'PAYE';
177: CURSOR CSR_INPUT_VALUE(P_IPV_NAME IN VARCHAR2) IS
178: SELECT
179: INPUT_VALUE_ID