APPS.IRC_GLOBAL_REMAP_PKG dependencies on PER_ADDRESSES

Line 7: l_add_ovn per_addresses.object_version_number%type;

3:
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;

Line 18: from per_addresses adr, per_all_people_f paf

14: cursor csr_address is
15: select adr.address_id,
16: adr.object_version_number,
17: paf.business_group_id as bg_id
18: from per_addresses adr, per_all_people_f paf
19: where paf.party_id = adr.party_id
20: and paf.person_id = p_person_id
21: and adr.person_id is null
22: and p_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 68: from per_addresses adr, per_all_people_f paf

64: select adr.address_id,
65: adr.object_version_number,
66: paf.business_group_id as bg_id,
67: paf.person_id as paf_person_id
68: from per_addresses adr, per_all_people_f paf
69: where paf.party_id = adr.party_id
70: and paf.current_employee_flag = 'Y'
71: and adr.person_id is null
72: and p_effective_date between paf.effective_start_date and paf.effective_end_date