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.JTF_RS_IMP_RES_PVT dependencies on PER_ALL_PEOPLE_F

Line 88: per_all_people_f ppl

84: ,ppl.office_number
85: ,ppl.internal_location
86: ,ppl.mailstop
87: FROM
88: per_all_people_f ppl
89: ,hr_all_organization_units org
90: ,per_assignments_f asg
91: ,per_jobs job
92: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645

Line 93: -- ,per_all_people_f pep removed the table since we can get the work_telephone from ppl

89: ,hr_all_organization_units org
90: ,per_assignments_f asg
91: ,per_jobs job
92: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645
93: -- ,per_all_people_f pep removed the table since we can get the work_telephone from ppl
94: ,per_all_people_f emp
95: WHERE ppl.person_id = l_person_id
96: AND trunc(sysdate) between trunc(ppl.effective_start_date) and trunc(ppl.effective_end_date)
97: -- AND ppl.employee_number is not null

Line 94: ,per_all_people_f emp

90: ,per_assignments_f asg
91: ,per_jobs job
92: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645
93: -- ,per_all_people_f pep removed the table since we can get the work_telephone from ppl
94: ,per_all_people_f emp
95: WHERE ppl.person_id = l_person_id
96: AND trunc(sysdate) between trunc(ppl.effective_start_date) and trunc(ppl.effective_end_date)
97: -- AND ppl.employee_number is not null
98: AND (ppl.current_employee_flag = 'Y' OR ppl.current_npw_flag = 'Y')

Line 147: per_all_people_f ppl

143: ,ppl.office_number
144: ,ppl.internal_location
145: ,ppl.mailstop
146: FROM
147: per_all_people_f ppl
148: ,hr_all_organization_units org
149: ,per_assignments_f asg
150: ,per_jobs job
151: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645

Line 152: -- ,per_all_people_f pep removed the table since we can get the work_telephone from ppl

148: ,hr_all_organization_units org
149: ,per_assignments_f asg
150: ,per_jobs job
151: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645
152: -- ,per_all_people_f pep removed the table since we can get the work_telephone from ppl
153: ,per_all_people_f emp
154: WHERE ppl.person_id = l_person_id
155: -- AND trunc(sysdate) between trunc(ppl.effective_start_date) and trunc(ppl.effective_end_date)
156: -- Enh 3947611 2-dec-2004:changed the date check for future dated employees.

Line 153: ,per_all_people_f emp

149: ,per_assignments_f asg
150: ,per_jobs job
151: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645
152: -- ,per_all_people_f pep removed the table since we can get the work_telephone from ppl
153: ,per_all_people_f emp
154: WHERE ppl.person_id = l_person_id
155: -- AND trunc(sysdate) between trunc(ppl.effective_start_date) and trunc(ppl.effective_end_date)
156: -- Enh 3947611 2-dec-2004:changed the date check for future dated employees.
157: AND trunc(sysdate) <= trunc(ppl.effective_end_date)

Line 198: WHERE parent_table = 'PER_ALL_PEOPLE_F'

194:
195: CURSOR phone_cur(l_person_id NUMBER) IS
196: SELECT phone_number
197: FROM per_phones per
198: WHERE parent_table = 'PER_ALL_PEOPLE_F'
199: AND parent_id = l_person_id
200: AND phone_type = 'W1'
201: AND date_from = (SELECT MAX(date_from)
202: FROM per_phones p2

Line 203: WHERE parent_table = 'PER_ALL_PEOPLE_F'

199: AND parent_id = l_person_id
200: AND phone_type = 'W1'
201: AND date_from = (SELECT MAX(date_from)
202: FROM per_phones p2
203: WHERE parent_table = 'PER_ALL_PEOPLE_F'
204: AND parent_id = l_person_id
205: AND phone_type = 'W1' );
206:
207: phone_rec phone_cur%rowtype;

Line 214: WHERE parent_table = 'PER_ALL_PEOPLE_F'

210:
211: CURSOR mobile_cur(l_person_id NUMBER) IS
212: SELECT phone_number
213: FROM per_phones per
214: WHERE parent_table = 'PER_ALL_PEOPLE_F'
215: and parent_id = l_person_id
216: and phone_type = 'M'
217: and date_from = (SELECT MAX(date_from)
218: FROM per_phones p2

Line 219: WHERE parent_table = 'PER_ALL_PEOPLE_F'

215: and parent_id = l_person_id
216: and phone_type = 'M'
217: and date_from = (SELECT MAX(date_from)
218: FROM per_phones p2
219: WHERE parent_table = 'PER_ALL_PEOPLE_F'
220: AND parent_id = l_person_id
221: AND phone_type = 'M' );
222:
223: mobile_rec mobile_cur%rowtype;

Line 228: WHERE parent_table = 'PER_ALL_PEOPLE_F'

224:
225: CURSOR pager_cur(l_person_id NUMBER) IS
226: SELECT phone_number
227: FROM per_phones per
228: WHERE parent_table = 'PER_ALL_PEOPLE_F'
229: and parent_id = l_person_id
230: and phone_type = 'P'
231: and date_from = (SELECT MAX(date_from)
232: FROM per_phones p2

Line 233: WHERE parent_table = 'PER_ALL_PEOPLE_F'

229: and parent_id = l_person_id
230: and phone_type = 'P'
231: and date_from = (SELECT MAX(date_from)
232: FROM per_phones p2
233: WHERE parent_table = 'PER_ALL_PEOPLE_F'
234: AND parent_id = l_person_id
235: AND phone_type = 'P' );
236:
237: pager_rec pager_cur%rowtype;