APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on PAY_INPUT_VALUES_F

Line 1731: from pay_input_values_f

1727: -- and p_effective_date between date_from and date_to;
1728:
1729: cursor c_ipvs(p_element_type_id in number, p_effective_date in date) is
1730: select display_sequence, name, input_value_id, mandatory_flag
1731: from pay_input_values_f
1732: where element_type_id = p_element_type_id
1733: and p_effective_date between effective_start_date and effective_end_date
1734: order by display_sequence, name;
1735: /*

Line 1774: pay_input_values_f piv,

1770: , NULL) UOM,
1771: pat.absence_category
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

Line 1801: l_attr_prompt pay_input_values_f.name%TYPE;

1797:
1798: -- change end
1799:
1800:
1801: l_attr_prompt pay_input_values_f.name%TYPE;
1802: l_temp_segment_choice NUMBER :=0;
1803:
1804: l_appl_short_name VARCHAR2(3) := 'HXC';
1805: l_flexfield_name VARCHAR2(30) := 'OTC Information Types';