DBA Data[Home] [Help]

APPS.PER_PAC_BUS dependencies on PER_ALL_PEOPLE_F

Line 33: , per_all_people_f paf

29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , per_allocated_checklists pac
33: , per_all_people_f paf
34: where pac.allocated_checklist_id = p_allocated_checklist_id
35: and pac.person_id = paf.person_id
36: and trunc(sysdate) between paf.EFFECTIVE_START_DATE
37: and paf.EFFECTIVE_END_DATE

Line 108: , per_all_people_f paf

104: select pbg.legislation_code
105: from per_business_groups_perf pbg
106: , per_allocated_checklists pac
107: -- , EDIT_HERE table_name(s) 333
108: , per_all_people_f paf
109: where pac.allocated_checklist_id = p_allocated_checklist_id
110: and pac.person_id = paf.person_id
111: and trunc(sysdate) between paf.EFFECTIVE_START_DATE
112: and paf.EFFECTIVE_END_DATE