APPS.IRC_GLOBAL_REMAP_PKG dependencies on PER_PHONES

Line 8: l_phn_ovn per_phones.object_version_number%type;

4: procedure remap_employee (p_person_id in number default null,
5: p_effective_date in date) is
6: --
7: l_add_ovn per_addresses.object_version_number%type;
8: l_phn_ovn per_phones.object_version_number%type;
9: l_prev_emp_ovn per_previous_employers.object_version_number%type;
10: l_qua_ovn per_qualifications.object_version_number%type;
11: l_esa_ovn per_establishment_attendances.object_version_number%type;
12: l_proc varchar2(72) := 'IRC_GLOBAL_REMAP_PKG.remap_employee';

Line 27: from per_phones phn, per_all_people_f paf

23:
24: cursor csr_phones is
25: select phn.phone_id,
26: phn.object_version_number
27: from per_phones phn, per_all_people_f paf
28: where phn.party_id=paf.party_id
29: and paf.person_id = p_person_id
30: and phn.parent_id is null
31: and p_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 85: from per_phones phn, per_all_people_f paf

81: cursor csr_all_phones is
82: select phn.phone_id,
83: phn.object_version_number,
84: paf.person_id as paf_person_id
85: from per_phones phn, per_all_people_f paf
86: where phn.party_id=paf.party_id
87: and paf.current_employee_flag = 'Y'
88: and phn.parent_id is null
89: and p_effective_date between paf.effective_start_date and paf.effective_end_date