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

Line 34: , per_all_people_f paf

30: pbg.legislation_code
31: FROM per_business_groups_perf pbg
32: , per_allocated_checklists pac
33: , per_allocated_tasks pat
34: , per_all_people_f paf
35: WHERE pat.allocated_task_id = p_allocated_task_id
36: AND pat.allocated_checklist_id = pac.allocated_checklist_id
37: AND pac.person_id = paf.person_id
38: AND TRUNC(SYSDATE) BETWEEN paf.EFFECTIVE_START_DATE

Line 111: , per_all_people_f paf

107: select pbg.legislation_code
108: FROM per_business_groups_perf pbg
109: , per_allocated_checklists pac
110: , per_allocated_tasks pat
111: , per_all_people_f paf
112: WHERE pat.allocated_task_id = p_allocated_task_id
113: AND pat.allocated_checklist_id = pac.allocated_checklist_id
114: AND pac.person_id = paf.person_id
115: AND TRUNC(SYSDATE) BETWEEN paf.EFFECTIVE_START_DATE