APPS.PAY_LINK_INPUT_VALUES_API dependencies on PAY_INPUT_VALUES_F

Line 36: l_rec pay_input_values_f%rowtype;

32: l_effective_date date;
33: l_effective_start_date date;
34: l_effective_end_date date;
35: l_exists varchar2(1);
36: l_rec pay_input_values_f%rowtype;
37: l_costable_type pay_element_links_f.costable_type%type;
38: l_default_value pay_link_input_values_f.default_value%type;
39: l_max_value pay_link_input_values_f.max_value%type;
40: l_min_value pay_link_input_values_f.min_value%type;

Line 50: from pay_input_values_f

46:
47: Cursor C_input_values
48: is
49: select *
50: from pay_input_values_f
51: where input_value_id = p_input_value_id
52: and p_effective_date between effective_start_date
53: and effective_end_date;
54:

Line 213: from pay_input_values_f

209:
210: Cursor c_lookup_type(p_input_value_id number)
211: is
212: select lookup_type
213: from pay_input_values_f
214: where input_value_id = p_input_value_id
215: and p_effective_date between effective_start_date
216: and effective_end_date;
217: