DBA Data[Home] [Help]

APPS.PE_PEI_BUS dependencies on PER_ALL_PEOPLE_F

Line 30: ,per_all_people_f per

26: cursor csr_leg_code is
27: select pbg.legislation_code
28: from per_business_groups pbg
29: ,per_people_extra_info pei
30: ,per_all_people_f per
31: where pei.person_extra_info_id = p_person_extra_info_id
32: and per.person_id = pei.person_id
33: and pbg.business_group_id = per.business_group_id;
34: --

Line 200: FROM per_all_people_f per -- Bug 4508101

196: l_person_found boolean := false;
197: --
198: cursor csr_person_id is
199: SELECT 1
200: FROM per_all_people_f per -- Bug 4508101
201: WHERE per.person_id = p_person_id;
202: --
203: begin
204: hr_utility.set_location('Entering:'||l_proc, 10);