7: P_EFFECTIVE_DATE IN DATE
8: ) return NUMBER is
9: cursor c_input_value is
10: select input_value_id
11: from pay_input_values_f
12: where element_type_id = p_element_type_id
13: and p_effective_date between effective_start_date and effective_end_date
14: order by display_sequence asc;
15:
186:
187: /* Always order the Input Values by Id in asc */
188: cursor c_input_values(p_element_type_id number) is
189: select * from
190: pay_input_values_f
191: where element_type_id = p_element_type_id
192: and p_effective_date between effective_start_date and effective_end_date
193: order by input_value_id asc;
194:
219: l_context_exists_flag boolean;
220: l_ss_config_exists_flag boolean;
221: l_lowest_seq_input_value_id number;
222: l_required varchar2(1);
223: l_input_value_id pay_input_values_f.input_value_id%TYPE;
224:
225: begin
226: hr_utility.set_location('Entering: '||l_proc,10);
227: