APPS.PER_NL_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_nl_qh_tax.';
7: --
8: procedure update_nl_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 23: update per_all_people_f

19: hr_utility.set_location('Entering:'|| l_proc, 10);
20: --
21: if p_legislation_code='NL' then
22: --
23: update per_all_people_f
24: set per_information1 = p_rec.tax_field1
25: ,per_information2 = p_rec.tax_field25
26: ,per_information3 = p_rec.tax_field26
27: ,per_information4 = p_rec.tax_field27

Line 40: update per_all_people_f

36: ,middle_names = p_rec.tax_field7
37: where person_id = p_person_id
38: and p_effective_date between effective_start_date and effective_end_date;
39: if p_rec.tax_field21 is null then
40: update per_all_people_f
41: set country_of_birth = null
42: where person_id = p_person_id
43: and p_effective_date between effective_start_date and effective_end_date;
44: end if;

Line 55: ,p_person_id in per_all_people_f.person_id%type

51: --
52:
53: procedure nl_tax_query
54: (p_rec in out nocopy per_qh_tax_query.taxrec
55: ,p_person_id in per_all_people_f.person_id%type
56: ,p_assignment_id in per_all_assignments_f.assignment_id%type
57: ,p_legislation_code in varchar2
58: ,p_effective_date in date
59: ) is

Line 143: from per_all_people_f

139: ,p_rec.tax_field7
140: ,p_rec.tax_field32
141: ,p_rec.tax_field22
142: ,p_rec.tax_field5
143: from per_all_people_f
144: where person_id = p_person_id
145: and p_effective_date between effective_start_date and effective_end_date
146: and rownum = 1;
147: Exception