APPS.PAY_PAYGBTPL_XMLP_PKG dependencies on PAY_INPUT_VALUES_F

Line 14: PAY_INPUT_VALUES_F PIV_SCON,

10: PIV_SCON.INPUT_VALUE_ID SCON_IV,
11: PIV_CAT.INPUT_VALUE_ID CAT_IV,
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'

Line 15: PAY_INPUT_VALUES_F PIV_CAT,

11: PIV_CAT.INPUT_VALUE_ID CAT_IV,
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'

Line 181: PAY_INPUT_VALUES_F

177: CURSOR CSR_INPUT_VALUE(P_IPV_NAME IN VARCHAR2) IS
178: SELECT
179: INPUT_VALUE_ID
180: FROM
181: PAY_INPUT_VALUES_F
182: WHERE ELEMENT_TYPE_ID = L_PAYE_ELEMENT_ID
183: AND NAME = P_IPV_NAME;
184: CURSOR CSR_RESULT_VALUE(P_IPV_ID IN NUMBER) IS
185: SELECT