eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_GLOBAL_REMAP_PKG dependencies on PER_ALL_PEOPLE_F

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 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 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 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 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 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

Line 73: and not exists (select 1 from per_all_people_f per2

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
73: and not exists (select 1 from per_all_people_f per2
74: where paf.party_id=per2.party_id
75: and paf.person_id<>per2.person_id
76: and per2.current_employee_flag='Y'
77: and p_effective_date between per2.effective_start_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

Line 90: and not exists (select 1 from per_all_people_f per2

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
90: and not exists (select 1 from per_all_people_f per2
91: where paf.party_id=per2.party_id
92: and paf.person_id<>per2.person_id
93: and per2.current_employee_flag='Y'
94: and p_effective_date between per2.effective_start_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

Line 108: and not exists (select 1 from per_all_people_f per2

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
108: and not exists (select 1 from per_all_people_f per2
109: where paf.party_id=per2.party_id
110: and paf.person_id<>per2.person_id
111: and per2.current_employee_flag='Y'
112: and p_effective_date between per2.effective_start_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

Line 127: and not exists (select 1 from per_all_people_f per2

123: and paf.current_employee_flag = 'Y'
124: and qua.person_id is null
125: and qua.attendance_id is null
126: and p_effective_date between paf.effective_start_date and paf.effective_end_date
127: and not exists (select 1 from per_all_people_f per2
128: where paf.party_id=per2.party_id
129: and paf.person_id<>per2.person_id
130: and per2.current_employee_flag='Y'
131: and p_effective_date between per2.effective_start_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

Line 145: and not exists (select 1 from per_all_people_f per2

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
145: and not exists (select 1 from per_all_people_f per2
146: where paf.party_id=per2.party_id
147: and paf.person_id<>per2.person_id
148: and per2.current_employee_flag='Y'
149: and p_effective_date between per2.effective_start_date

Line 190: ,p_parent_table => 'PER_ALL_PEOPLE_F'

186: hr_utility.set_location('Updating phones:'||l_proc, 45);
187: per_phn_upd.upd
188: (p_phone_id => c_phn_rec.phone_id
189: ,p_parent_id => p_person_id
190: ,p_parent_table => 'PER_ALL_PEOPLE_F'
191: ,p_object_version_number => l_phn_ovn
192: ,p_effective_date => p_effective_date
193: );
194: end loop;

Line 290: ,p_parent_table => 'PER_ALL_PEOPLE_F'

286: hr_utility.set_location('Updating phones:'||l_proc, 145);
287: per_phn_upd.upd
288: (p_phone_id => c_phn_rec.phone_id
289: ,p_parent_id => c_phn_rec.paf_person_id
290: ,p_parent_table => 'PER_ALL_PEOPLE_F'
291: ,p_object_version_number => l_phn_ovn
292: ,p_effective_date => p_effective_date
293: );
294: end loop;