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_CHECKLIST_EVENTS dependencies on PER_ALL_PEOPLE_F

Line 852: FROM per_all_people_f papf

848: --
849: -- Added effective date in place of sysdate to enable checklist notification for future dated employees as per Bug#12385504
850: /*CURSOR csr_person_name is
851: SELECT papf.full_name
852: FROM per_all_people_f papf
853: WHERE papf.person_id = p_person_id
854: AND
855: (
856: SELECT max (ppos.date_start)

Line 864: FROM per_all_people_f papf,

860: AND papf.effective_end_date;*/ --Commented for Bug#12385504
861:
862: CURSOR csr_person_name is
863: SELECT papf.full_name
864: FROM per_all_people_f papf,
865: (
866: SELECT to_date(max (ppos.date_start)) effective_date
867: FROM per_periods_of_service ppos
868: WHERE ppos.person_id = p_person_id

Line 873: FROM per_all_people_f

869: ) ppfe
870: WHERE papf.person_id = p_person_id
871: AND papf.effective_start_date =
872: NVL(ppfe.effective_date,(SELECT to_date(max (effective_start_date))
873: FROM per_all_people_f
874: WHERE person_id = p_person_id));
875:
876:
877: -- End of changes as per Bug#12385504