APPS.PQP_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPE_RULES

Line 11: FROM pay_element_type_rules petr

7: -- Cursor to get all the element type ids from an element set
8: -- =============================================================================
9: CURSOR csr_ele_id (c_element_set_id IN NUMBER) IS
10: SELECT DISTINCT petr.element_type_id
11: FROM pay_element_type_rules petr
12: WHERE petr.element_set_id = c_element_set_id
13: AND petr.include_or_exclude = 'I'
14: UNION ALL
15: SELECT DISTINCT pet1.element_type_id

Line 23: FROM pay_element_type_rules petr

19: FROM pay_ele_classification_rules
20: WHERE element_set_id = c_element_set_id)
21: MINUS
22: SELECT DISTINCT petr.element_type_id
23: FROM pay_element_type_rules petr
24: WHERE petr.element_set_id = c_element_set_id
25: AND petr.include_or_exclude = 'E';
26:
27: -- =============================================================================