DBA Data[Home] [Help]

APPS.PER_CHK_BUS dependencies on PER_ALL_PEOPLE_F

Line 30: , per_all_people_f peo

26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_checklist_items chk
30: , per_all_people_f peo
31: where chk.checklist_item_id = p_checklist_item_id
32: and chk.person_id = peo.person_id
33: and pbg.business_group_id = peo.business_group_id;
34: --

Line 90: , per_all_people_f peo

86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , per_checklist_items chk
90: , per_all_people_f peo
91: where chk.checklist_item_id = p_checklist_item_id
92: and chk.person_id = peo.person_id
93: and pbg.business_group_id = peo.business_group_id;
94: --

Line 262: FROM per_all_people_f

258: --
259: CURSOR chk_valid_person
260: IS
261: SELECT person_id
262: FROM per_all_people_f
263: WHERE person_id = p_person_id;
264:
265: l_person_id per_checklist_items.person_id%TYPE;
266: