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_PEOPLE_F

Line 223: per_people_f ppf

219:
220: /*
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/'')

Line 283: per_people_f ppf

279: ) is
280: select distinct paf.assignment_id
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

Line 293: from per_people_f ppf2

289: between to_date(g_start_date,'YYYY/MM/DD/')
290: and to_date(g_end_date,'YYYY/MM/DD/')
291: and ppf.effective_start_date =
292: (select max(ppf2.effective_start_date)
293: from per_people_f ppf2
294: where ppf2.person_id = ppf.person_id
295: and ppf2.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')
296: and ppf2.effective_end_date >= to_date(g_start_date,'YYYY/MM/DD/')
297: )

Line 381: per_people_f ppf

377: /* commented for the bug# 5344584(Base bug# 5212175) */
378: /* select distinct paf.assignment_id
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

Line 394: from per_people_f ppf2

390: and paf.effective_end_date >= to_date(g_start_date,'YYYY/MM/DD/')
391: and ppf.current_employee_flag = 'Y'
392: and ppf.effective_start_date =
393: (select max(ppf2.effective_start_date)
394: from per_people_f ppf2
395: where ppf2.person_id = ppf.person_id
396: and ppf2.current_employee_flag = 'Y'
397: and ppf2.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')
398: and ppf2.effective_end_date >= to_date(g_start_date,'YYYY/MM/DD/')

Line 478: per_people_f ppf

474: ) is
475: select distinct paf.assignment_id
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

Line 498: from per_people_f ppf2

494: and ppt.person_type_id = ptu.person_type_id
495: and ppt.system_person_type = 'RETIREE'
496: and ppf.effective_start_date =
497: (select max(ppf2.effective_start_date)
498: from per_people_f ppf2
499: where ppf2.person_id = ppf.person_id
500: and ppf2.current_employee_flag is null
501: )
502: and ppf.person_id = paf.person_id

Line 716: per_people_f ppf

712: ,substr(ppf.SEX,1,1) GENDER
713: --,paf.ASSIGNMENT_ID
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

Line 731: from per_people_f ppf2

727: and paf.effective_end_date >= p_start_date
728: and ppf.current_employee_flag = 'Y'
729: and ppf.effective_start_date =
730: (select max(ppf2.effective_start_date)
731: from per_people_f ppf2
732: where ppf2.person_id = ppf.person_id
733: and ppf2.current_employee_flag = 'Y'
734: and ppf2.effective_start_date <= p_end_date
735: and ppf2.effective_end_date >= p_start_date

Line 761: per_people_f ppf

757: ,substr(ppf.SEX,1,1) GENDER
758: --,paf.ASSIGNMENT_ID
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

Line 771: from per_people_f ppf2

767: and pps.date_start between
768: p_start_date and p_end_date
769: and ppf.effective_start_date =
770: (select max(ppf2.effective_start_date)
771: from per_people_f ppf2
772: where ppf2.person_id = ppf.person_id
773: and ppf2.effective_start_date <= p_end_date
774: and ppf2.effective_end_date >= p_start_date
775: )

Line 800: per_people_f ppf

796: ,substr(ppf.SEX,1,1) GENDER
797: --,paf.ASSIGNMENT_ID
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

Line 819: from per_people_f ppf2

815: and ppt.person_type_id = ptu.person_type_id
816: and ppt.system_person_type = 'RETIREE'
817: and ppf.effective_start_date =
818: (select max(ppf2.effective_start_date)
819: from per_people_f ppf2
820: where
821: ppf2.person_id = ppf.person_id
822: and ppf2.current_employee_flag is null
823: )

Line 854: per_people_f ppf

850: ,substr(ppf.SEX,1,1) GENDER
851: --,paf.ASSIGNMENT_ID
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

Line 873: from per_people_f ppf2

869: and ppt.person_type_id = ptu.person_type_id
870: and ppt.system_person_type = 'RETIREE'
871: and ppf.effective_start_date =
872: (select max(ppf2.effective_start_date)
873: from per_people_f ppf2
874: where
875: ppf2.person_id = ppf.person_id
876: and ppf2.current_employee_flag is null
877: )

Line 892: from per_people_f ppf2

888: And paf.primary_flag = 'Y'
889: And ppf.business_group_id +0 = p_business_group_id
890: and exists
891: (select null
892: from per_people_f ppf2
893: ,per_periods_of_service pps2
894: where
895: ppf2.person_id = ppf.person_id
896: and ppf2.current_employee_flag = 'Y'