156: where petr.element_type_id = cp_element_type_id
157: and petr.include_or_exclude = 'I'
158: union all
159: select pes.element_set_id
160: from pay_ele_classification_rules pecr,
161: pay_element_types_f pet,
162: pay_element_sets pes
163: where pet.classification_id = pecr.classification_id
164: and pes.element_set_id = pecr.element_set_id
277: where petr.element_type_id = cp_element_type_id
278: and petr.include_or_exclude = 'I'
279: union all
280: select pes.element_set_id
281: from pay_ele_classification_rules pecr,
282: pay_element_types_f pet,
283: pay_element_sets pes
284: where pet.classification_id = pecr.classification_id
285: and pes.element_set_id = pecr.element_set_id