APPS.IRC_GLOBAL_REMAP_PKG dependencies on PER_QUALIFICATIONS

Line 10: l_qua_ovn per_qualifications.object_version_number%type;

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: --
14: cursor csr_address is

Line 47: from per_qualifications qua, per_all_people_f paf

43: cursor csr_qual is
44: select qua.qualification_id,
45: qua.object_version_number,
46: paf.business_group_id as bg_id
47: from per_qualifications qua, per_all_people_f paf
48: where qua.party_id=paf.party_id
49: and paf.person_id = p_person_id
50: and qua.person_id is null
51: and p_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 121: from per_qualifications qua, per_all_people_f paf

117: select qua.qualification_id,
118: qua.object_version_number,
119: paf.business_group_id as bg_id,
120: paf.person_id as paf_person_id
121: from per_qualifications qua, per_all_people_f paf
122: where qua.party_id=paf.party_id
123: and paf.current_employee_flag = 'Y'
124: and qua.person_id is null
125: and qua.attendance_id is null