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
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