APPS.PER_IT_QH_TAX dependencies on PER_ALL_ASSIGNMENTS_F

Line 11: ,p_assignment_id in per_all_assignments_f.assignment_id%type

7: --
8: procedure update_it_tax_data
9: (p_rec in out nocopy per_qh_tax_query.taxrec
10: ,p_person_id in per_all_people_f.person_id%type
11: ,p_assignment_id in per_all_assignments_f.assignment_id%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';

Line 60: from per_all_assignments_f

56: ,p_ccid => l_new_cagr_grade_def_id
57: ,p_concat_segments_out => l_concat_segments);
58: Begin
59: select cagr_grade_def_id into l_old_cagr_grade_def_id
60: from per_all_assignments_f
61: where person_id = p_person_id
62: and assignment_id = p_assignment_id
63: and cagr_id_flex_num = l_id_flex_num
64: and p_effective_date between effective_start_date and effective_end_date

Line 68: update per_all_assignments_f

64: and p_effective_date between effective_start_date and effective_end_date
65: and rownum = 1;
66: if l_old_cagr_grade_def_id <> l_new_cagr_grade_def_id then
67: if(p_rec.tax_field6 is not null) then ---bug 3878097
68: update per_all_assignments_f
69: set cagr_grade_def_id = l_new_cagr_grade_def_id,
70: collective_agreement_id = p_rec.tax_field6,
71: cagr_id_flex_num = l_id_flex_num
72: where person_id = p_person_id

Line 77: update per_all_assignments_f

73: and assignment_id = p_assignment_id
74: and cagr_id_flex_num = l_id_flex_num
75: and p_effective_date between effective_start_date and effective_end_date;
76: else ---bug 3878097
77: update per_all_assignments_f
78: set cagr_grade_def_id = null, -- added to not populate id_flex_num if no collective agreement id is found
79: collective_agreement_id = p_rec.tax_field6,
80: cagr_id_flex_num = null
81: where person_id = p_person_id

Line 90: update per_all_assignments_f

86: end if;
87: EXCEPTION
88: when no_data_found then
89: if(p_rec.tax_field6 is not null) then ---bug 3878097
90: update per_all_assignments_f
91: set cagr_grade_def_id = l_new_cagr_grade_def_id,
92: collective_agreement_id = p_rec.tax_field6,
93: cagr_id_flex_num = l_id_flex_num
94: where person_id = p_person_id

Line 98: update per_all_assignments_f

94: where person_id = p_person_id
95: and assignment_id = p_assignment_id
96: and p_effective_date between effective_start_date and effective_end_date;
97: else ---bug 3878097
98: update per_all_assignments_f
99: set cagr_grade_def_id = null,
100: collective_agreement_id = p_rec.tax_field6,
101: cagr_id_flex_num = null
102: where person_id = p_person_id

Line 118: ,p_assignment_id in per_all_assignments_f.assignment_id%type

114:
115: procedure it_tax_query
116: (p_rec in out nocopy per_qh_tax_query.taxrec
117: ,p_person_id in per_all_people_f.person_id%type
118: ,p_assignment_id in per_all_assignments_f.assignment_id%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';

Line 156: from per_all_assignments_f

152: null;
153: End;
154: Begin
155: select cagr_grade_def_id into l_old_cagr_grade_def_id
156: from per_all_assignments_f
157: where person_id = p_person_id
158: and assignment_id = p_assignment_id
159: and cagr_id_flex_num = l_id_flex_num
160: and p_effective_date between effective_start_date and effective_end_date