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_ASSIGNMENTS_F

Line 225: ,per_assignments_f paf

221: 'select distinct ppf.person_id
222: from
223: per_people_f ppf
224: ,hr_soft_coding_keyflex hsck
225: ,per_assignments_f paf
226: where ppf.person_id = paf.person_id
227: and ppf.effective_start_date <= to_date('''||g_end_date||''',''YYYY/MM/DD/'')
228: and ppf.effective_end_date >= to_date('''||g_start_date||''',''YYYY/MM/DD/'')
229: and paf.effective_start_date <= to_date('''|| g_end_date||''',''YYYY/MM/DD/'')

Line 285: ,per_assignments_f paf

281: ,hsck.segment1
282: from
283: per_people_f ppf
284: ,hr_soft_coding_keyflex hsck
285: ,per_assignments_f paf
286: ,per_periods_of_service pps
287: where ppf.person_id = pps.person_id
288: and pps.date_start
289: between to_date(g_start_date,'YYYY/MM/DD/')

Line 383: ,per_assignments_f paf

379: ,hsck.segment1
380: from
381: per_people_f ppf
382: ,hr_soft_coding_keyflex hsck
383: ,per_assignments_f paf
384: ,per_periods_of_service pps
385: ,per_assignment_status_types past
386: where ppf.person_id = paf.person_id
387: and ppf.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')

Line 480: ,per_assignments_f paf

476: ,hsck.segment1
477: from
478: per_people_f ppf
479: ,hr_soft_coding_keyflex hsck
480: ,per_assignments_f paf
481: ,per_periods_of_service pps
482: ,per_person_type_usages_f ptu
483: ,per_person_types ppt
484: where ppf.person_id = pps.person_id

Line 505: from per_assignments_f paf2

501: )
502: and ppf.person_id = paf.person_id
503: and paf.effective_start_date =
504: (select max(paf2.effective_start_date)
505: from per_assignments_f paf2
506: where paf.assignment_id = paf2.assignment_id
507: )
508: and hsck.segment1 in
509: (

Line 718: ,per_assignments_f paf

714:
715: From
716: per_people_f ppf
717: ,hr_soft_coding_keyflex hsck
718: ,per_assignments_f paf
719: ,per_periods_of_service pps
720: ,per_assignment_status_types past
721: Where
722: pps.person_id = ppf.person_id

Line 763: ,per_assignments_f paf

759:
760: From
761: per_people_f ppf
762: ,hr_soft_coding_keyflex hsck
763: ,per_assignments_f paf
764: ,per_periods_of_service pps
765: Where
766: ppf.person_id = pps.person_id
767: and pps.date_start between

Line 802: ,per_assignments_f paf

798:
799: From
800: per_people_f ppf
801: ,hr_soft_coding_keyflex hsck
802: ,per_assignments_f paf
803: ,per_periods_of_service pps
804: ,per_person_type_usages_f ptu
805: ,per_person_types ppt
806: Where

Line 827: from per_assignments_f paf2

823: )
824: and ppf.person_id = paf.person_id
825: and paf.effective_start_date =
826: (select max(paf2.effective_start_date)
827: from per_assignments_f paf2
828: where
829: paf.assignment_id = paf2.assignment_id
830: )
831: And hsck.segment1 = to_char(p_tax_unit_id)

Line 856: ,per_assignments_f paf

852:
853: From
854: per_people_f ppf
855: ,hr_soft_coding_keyflex hsck
856: ,per_assignments_f paf
857: ,per_periods_of_service pps
858: ,per_person_type_usages_f ptu
859: ,per_person_types ppt
860: Where

Line 881: from per_assignments_f paf2

877: )
878: and ppf.person_id = paf.person_id
879: and paf.effective_start_date =
880: (select max(paf2.effective_start_date)
881: from per_assignments_f paf2
882: where
883: paf.assignment_id = paf2.assignment_id
884: )
885: And hsck.segment1 = to_char(p_tax_unit_id)