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.PER_EVS_MAG_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 164: ,per_all_assignments_f paf

160: 'SELECT /*+ INDEX(hsck,HR_SOFT_CODING_KEYFLEX_PK),
161: INDEX(HR_ORGANIZATION_UNITS_PK,hou)*/
162: DISTINCT ppf.person_id
163: FROM per_all_people_f ppf
164: ,per_all_assignments_f paf
165: ,hr_soft_coding_keyflex hsck
166: ,hr_organization_units hou
167: ,hr_organization_information hoi
168: WHERE paf.assignment_type = ''E''

Line 195: ,per_all_assignments_f paf

191: -- Bug: 5212175
192:
193: 'select distinct ppf.person_id
194: from per_all_people_f ppf
195: ,per_all_assignments_f paf
196: ,hr_soft_coding_keyflex hsck
197: ,hr_organization_units hou
198: ,hr_organization_information hoi
199: where paf.assignment_type = ''E''

Line 340: per_all_assignments_f paf,

336: select /*+ index(hou,HR_ORGANIZATION_UNITS_FK1)*/
337: distinct paf.assignment_id,
338: hsck.segment1
339: from per_all_people_f ppf ,
340: per_all_assignments_f paf,
341: hr_soft_coding_keyflex hsck,
342: hr_all_organization_units hou,
343: hr_organization_information hoi,
344: per_assignment_status_types past

Line 429: ,per_all_assignments_f paf

425: */
426: /* commented for bug# 5687781
427: select distinct paf.assignment_id, hsck.segment1
428: from per_all_people_f ppf
429: ,per_all_assignments_f paf
430: ,hr_soft_coding_keyflex hsck
431: ,hr_organization_units hou
432: ,hr_organization_information hoi
433: ,per_assignment_status_types past