435: -- 115.24 Change
436: cursor c_elements(p_element_set_id in number, p_effective_date in date) is
437: select pet.element_type_id
438: from pay_element_types_f pet,
439: pay_element_type_rules per
440: where per.element_set_id = p_element_set_id
441: and per.include_or_exclude = 'I'
442: and per.element_type_id = pet.element_type_id
443: and multiple_entries_allowed_flag = 'Y'
1702:
1703: cursor c_elements(p_element_set_id in number, p_effective_date in date) is
1704: select pet.element_name, pet.element_type_id, pet.reporting_name
1705: from pay_element_types_f pet,
1706: pay_element_type_rules per
1707: where per.element_set_id = p_element_set_id
1708: and per.include_or_exclude = 'I'
1709: and per.element_type_id = pet.element_type_id
1710: and multiple_entries_allowed_flag = 'Y'
1772: from
1773: pay_element_types_f pet ,
1774: pay_input_values_f piv,
1775: per_absence_attendance_types pat,
1776: pay_element_type_rules per
1777: where
1778: per.element_set_id= p_element_set_id AND
1779: per.include_or_exclude = 'I' AND
1780: per.element_type_id=pet.element_type_id AND