APPS.PER_IT_QH_TAX dependencies on PER_CAGR_GRADES_DEF

Line 16: l_cagr_segment1 per_cagr_grades_def.segment1%type;

12: ,p_legislation_code in varchar2
13: ,p_effective_date in date
14: ) is
15: l_proc varchar2(72) := g_package||'update_it_tax_data';
16: l_cagr_segment1 per_cagr_grades_def.segment1%type;
17: l_cagr_segment2 per_cagr_grades_def.segment2%type;
18: l_cagr_segment3 per_cagr_grades_def.segment3%type;
19: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%type;
20: l_new_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;

Line 17: l_cagr_segment2 per_cagr_grades_def.segment2%type;

13: ,p_effective_date in date
14: ) is
15: l_proc varchar2(72) := g_package||'update_it_tax_data';
16: l_cagr_segment1 per_cagr_grades_def.segment1%type;
17: l_cagr_segment2 per_cagr_grades_def.segment2%type;
18: l_cagr_segment3 per_cagr_grades_def.segment3%type;
19: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%type;
20: l_new_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;
21: l_old_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;

Line 18: l_cagr_segment3 per_cagr_grades_def.segment3%type;

14: ) is
15: l_proc varchar2(72) := g_package||'update_it_tax_data';
16: l_cagr_segment1 per_cagr_grades_def.segment1%type;
17: l_cagr_segment2 per_cagr_grades_def.segment2%type;
18: l_cagr_segment3 per_cagr_grades_def.segment3%type;
19: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%type;
20: l_new_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;
21: l_old_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;
22: l_collective_agreement_id per_coll_agree_grades_v.collective_agreement_id%type;

Line 20: l_new_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;

16: l_cagr_segment1 per_cagr_grades_def.segment1%type;
17: l_cagr_segment2 per_cagr_grades_def.segment2%type;
18: l_cagr_segment3 per_cagr_grades_def.segment3%type;
19: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%type;
20: l_new_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;
21: l_old_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%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;

Line 21: l_old_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;

17: l_cagr_segment2 per_cagr_grades_def.segment2%type;
18: l_cagr_segment3 per_cagr_grades_def.segment3%type;
19: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%type;
20: l_new_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;
21: l_old_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%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;

Line 123: l_cagr_segment1 per_cagr_grades_def.segment1%type;

119: ,p_legislation_code in varchar2
120: ,p_effective_date in date
121: ) is
122: l_proc varchar2(72) := g_package||'it_tax_query';
123: l_cagr_segment1 per_cagr_grades_def.segment1%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;

Line 124: l_cagr_segment2 per_cagr_grades_def.segment2%type;

120: ,p_effective_date in date
121: ) is
122: l_proc varchar2(72) := g_package||'it_tax_query';
123: l_cagr_segment1 per_cagr_grades_def.segment1%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;

Line 125: l_cagr_segment3 per_cagr_grades_def.segment3%type;

121: ) is
122: l_proc varchar2(72) := g_package||'it_tax_query';
123: l_cagr_segment1 per_cagr_grades_def.segment1%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: --

Line 126: l_new_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;

122: l_proc varchar2(72) := g_package||'it_tax_query';
123: l_cagr_segment1 per_cagr_grades_def.segment1%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

Line 127: l_old_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%type;

123: l_cagr_segment1 per_cagr_grades_def.segment1%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: --

Line 164: from per_cagr_grades_def

160: and p_effective_date between effective_start_date and effective_end_date
161: and rownum = 1;
162:
163: select segment1, segment2, segment3 into l_cagr_segment1, l_cagr_segment2, l_cagr_segment3
164: from per_cagr_grades_def
165: where cagr_grade_def_id = l_old_cagr_grade_def_id
166: and id_flex_num = l_id_flex_num
167: and rownum = 1;
168: p_rec.tax_field3 := l_cagr_segment1;