APPS.PER_IT_QH_TAX dependencies on PER_ALL_PEOPLE_F

Line 10: ,p_person_id in per_all_people_f.person_id%type

6: g_package varchar2(33) := ' per_it_qh_tax.';
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

Line 36: update per_all_people_f

32: if p_legislation_code='IT' then
33: --
34: Begin
35: If p_rec.tax_field1 is not null Then
36: update per_all_people_f
37: set per_information2 = p_rec.tax_field1
38: where person_id = p_person_id
39: and p_effective_date between effective_start_date and effective_end_date;
40: End If;

Line 117: ,p_person_id in per_all_people_f.person_id%type

113: --
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

Line 137: from per_all_people_f

133: hr_utility.set_location('Entering:'|| l_proc, 10);
134: --
135: Begin
136: select per_information2 into p_rec.tax_field1
137: from per_all_people_f
138: where person_id = p_person_id
139: and p_effective_date between effective_start_date and effective_end_date
140: and rownum = 1;
141: EXCEPTION