APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPE_RULES

Line 9: FROM pay_element_type_rules petr

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

Line 21: FROM pay_element_type_rules petr

17: FROM pay_ele_classification_rules
18: WHERE element_set_id = c_element_set_id)
19: MINUS
20: SELECT DISTINCT petr.element_type_id
21: FROM pay_element_type_rules petr
22: WHERE petr.element_set_id = c_element_set_id
23: AND petr.include_or_exclude = 'E';
24: -- =============================================================================
25: -- Cursor to get input value id for a give element type id and input name