APPS.PAY_ES_NIE_UPDATE dependencies on PER_ALL_PEOPLE_F

Line 10: from hr_organization_information org, per_all_people_f p

6:
7: cursor get_NIE_value is
8: select per_information2 identifier_type,
9: per_information3 identifier_value
10: from hr_organization_information org, per_all_people_f p
11: where p.person_id = p_person_id
12: and org.organization_id = p.business_group_id
13: and org.org_information_context = 'Business Group Information'
14: and org.org_information9 = 'ES';

Line 48: from per_all_people_f

44: cursor get_NIE_value is
45: select per_information2 identifier_type,
46: per_information3 identifier_value,
47: effective_start_date, effective_end_date
48: from per_all_people_f
49: where person_id = p_person_id ;
50:
51: CURSOR get_legislation_code IS
52: select org_information9

Line 53: from hr_organization_information org, per_all_people_f p

49: where person_id = p_person_id ;
50:
51: CURSOR get_legislation_code IS
52: select org_information9
53: from hr_organization_information org, per_all_people_f p
54: where org.org_information_context = 'Business Group Information'
55: and org.organization_id = p.business_group_id
56: and p.person_id = p_person_id ;
57:

Line 86: update per_all_people_f

82: if l_qualifier = 'Y' then
83: l_updated_NIE := substr(l_identifier_value,1,1)
84: || '0'
85: || substr(l_identifier_value,2);
86: update per_all_people_f
87: set per_information3 = l_updated_NIE
88: where person_id = p_person_id
89: and effective_start_date = NIE_rec.effective_start_date
90: and effective_end_date = NIE_rec.effective_end_date ;