APPS.IRC_GLOBAL_REMAP_PKG dependencies on PER_PREVIOUS_EMPLOYERS

Line 9: l_prev_emp_ovn per_previous_employers.object_version_number%type;

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';
13: --

Line 37: from per_previous_employers pem, per_all_people_f paf

33: cursor csr_prev_emp is
34: select pem.previous_employer_id,
35: pem.object_version_number,
36: paf.business_group_id as bg_id
37: from per_previous_employers pem, per_all_people_f paf
38: where pem.party_id=paf.party_id
39: and paf.person_id = p_person_id
40: and pem.person_id is null
41: and p_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 103: from per_previous_employers pem, per_all_people_f paf

99: select pem.previous_employer_id,
100: pem.object_version_number,
101: paf.business_group_id as bg_id,
102: paf.person_id as paf_person_id
103: from per_previous_employers pem, per_all_people_f paf
104: where pem.party_id=paf.party_id
105: and paf.current_employee_flag = 'Y'
106: and pem.person_id is null
107: and p_effective_date between paf.effective_start_date and paf.effective_end_date