DBA Data[Home] [Help]

APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on PAY_ELEMENT_TYPE_RULES

Line 360: pay_element_type_rules per

356: -- 115.24 Change
357: cursor c_elements(p_element_set_id in number, p_effective_date in date) is
358: select pet.element_type_id
359: from pay_element_types_f pet,
360: pay_element_type_rules per
361: where per.element_set_id = p_element_set_id
362: and per.include_or_exclude = 'I'
363: and per.element_type_id = pet.element_type_id
364: and multiple_entries_allowed_flag = 'Y'

Line 1479: pay_element_type_rules per

1475:
1476: cursor c_elements(p_element_set_id in number, p_effective_date in date) is
1477: select pet.element_name, pet.element_type_id, pet.reporting_name
1478: from pay_element_types_f pet,
1479: pay_element_type_rules per
1480: where per.element_set_id = p_element_set_id
1481: and per.include_or_exclude = 'I'
1482: and per.element_type_id = pet.element_type_id
1483: and multiple_entries_allowed_flag = 'Y'