APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on PAY_INPUT_VALUES_F

Line 1504: from pay_input_values_f

1500: -- and p_effective_date between date_from and date_to;
1501:
1502: cursor c_ipvs(p_element_type_id in number, p_effective_date in date) is
1503: select display_sequence, name, input_value_id, mandatory_flag
1504: from pay_input_values_f
1505: where element_type_id = p_element_type_id
1506: and p_effective_date between effective_start_date and effective_end_date
1507: order by display_sequence, name;
1508: /*

Line 1521: l_attr_prompt pay_input_values_f.name%TYPE;

1517: from hxc_alias_values
1518: where alias_definition_id = p_an_id
1519: AND (alias_value_name like '% ~ '||p_ele_rep_name or alias_value_name = p_ele_rep_name);
1520:
1521: l_attr_prompt pay_input_values_f.name%TYPE;
1522: l_temp_segment_choice NUMBER :=0;
1523:
1524: l_appl_short_name VARCHAR2(3) := 'HXC';
1525: l_flexfield_name VARCHAR2(30) := 'OTC Information Types';