APPS.BEN_ICD_FLEX_FIELD_SETUP dependencies on PAY_ELEMENT_TYPES_F

Line 197: pay_element_types_f

193: order by input_value_id asc;
194:
195: cursor c_element_type(p_element_type_id number) is
196: select * from
197: pay_element_types_f
198: where element_type_id = p_element_type_id
199: and p_effective_date between effective_start_date and effective_end_date;
200:
201: i Number;

Line 205: l_element_type_id pay_element_types_f.element_type_id%TYPE;

201: i Number;
202: j Number;
203: n Number;
204: l_proc varchar2(100) := g_package||'create_icd_config';
205: l_element_type_id pay_element_types_f.element_type_id%TYPE;
206: l_element_entry_id number;
207: l_context_code FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE;
208: l_element_type pay_element_types_f%ROWTYPE;
209: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

Line 208: l_element_type pay_element_types_f%ROWTYPE;

204: l_proc varchar2(100) := g_package||'create_icd_config';
205: l_element_type_id pay_element_types_f.element_type_id%TYPE;
206: l_element_entry_id number;
207: l_context_code FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE;
208: l_element_type pay_element_types_f%ROWTYPE;
209: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
210: l_lookup_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
211: l_minmax_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
212: l_dataformat_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;