APPS.IRC_GLOBAL_REMAP_PKG dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 11: l_esa_ovn per_establishment_attendances.object_version_number%type;

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
15: select adr.address_id,

Line 57: from per_establishment_attendances pea, per_all_people_f paf

53: cursor csr_estab_attend is
54: select pea.attendance_id,
55: pea.object_version_number,
56: paf.business_group_id as bg_id
57: from per_establishment_attendances pea, per_all_people_f paf
58: where pea.party_id=paf.party_id
59: and paf.person_id = p_person_id
60: and pea.person_id is null
61: and p_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 140: from per_establishment_attendances pea, per_all_people_f paf

136: select pea.attendance_id,
137: pea.object_version_number,
138: paf.business_group_id as bg_id,
139: paf.person_id as paf_person_id
140: from per_establishment_attendances pea, per_all_people_f paf
141: where pea.party_id=paf.party_id
142: and paf.current_employee_flag = 'Y'
143: and pea.person_id is null
144: and p_effective_date between paf.effective_start_date and paf.effective_end_date