APPS.PER_IT_QH_TAX dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 26: l_id_flex_num fnd_id_flex_structures_vl.id_flex_num%type;

22: l_collective_agreement_id per_coll_agree_grades_v.collective_agreement_id%type;
23: l_d_grade_type_name per_coll_agree_grades_v.d_grade_type_name%type;
24: l_business_group_id per_coll_agree_grades_v.business_group_id%type;
25: l_dynamic_insert_allowed per_coll_agree_grades_v.dynamic_insert_allowed%type;
26: l_id_flex_num fnd_id_flex_structures_vl.id_flex_num%type;
27: --
28: begin
29: --
30: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 42: from fnd_id_flex_structures_vl

38: where person_id = p_person_id
39: and p_effective_date between effective_start_date and effective_end_date;
40: End If;
41: select id_flex_num into l_id_flex_num
42: from fnd_id_flex_structures_vl
43: where id_flex_structure_name = 'IT_CAGR'
44: and id_flex_code = 'CAGR';
45: EXCEPTION
46: when no_data_found then

Line 128: l_id_flex_num fnd_id_flex_structures_vl.id_flex_num%type;

124: l_cagr_segment2 per_cagr_grades_def.segment2%type;
125: l_cagr_segment3 per_cagr_grades_def.segment3%type;
126: l_new_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;
127: l_old_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;
128: l_id_flex_num fnd_id_flex_structures_vl.id_flex_num%type;
129: --
130: begin
131: --
132: if p_legislation_code='IT' then

Line 147: from fnd_id_flex_structures_vl

143: null;
144: End;
145: Begin
146: select id_flex_num into l_id_flex_num
147: from fnd_id_flex_structures_vl
148: where id_flex_structure_name = 'IT_CAGR'
149: and id_flex_code = 'CAGR';
150: EXCEPTION
151: when no_data_found then