DBA Data[Home] [Help]

APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on PAY_ELEMENT_TYPE_RULES

Line 439: pay_element_type_rules per

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'

Line 1706: pay_element_type_rules per

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'

Line 1776: pay_element_type_rules per

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