APPS.PER_ROL_BUS dependencies on PER_PEOPLE_F

Line 30: , per_people_f per

26: cursor csr_sec_grp is
27: select null
28: from hr_organization_information hoi
29: , per_roles rol
30: , per_people_f per
31: where rol.role_id = p_role_id
32: and per.person_id = rol.person_id
33: and hoi.organization_id = per.business_group_id
34: and hoi.org_information_context||'' = 'Business Group Information';

Line 93: , per_people_f per

89: cursor csr_leg_code is
90: select pbg.legislation_code
91: from per_business_groups pbg
92: , per_roles rol
93: , per_people_f per
94: where rol.role_id = p_role_id
95: and rol.person_id = per.person_id
96: and per.business_group_id = pbg.business_group_id;
97: --

Line 195: from per_people_f per

191: l_dummy number;
192: --
193: cursor csr_person_id is
194: select null
195: from per_people_f per
196: where per.person_id = p_person_id
197: and p_effective_date between per.effective_start_date
198: and per.effective_end_date;
199: --

Line 215: -- Check that the person_id is in the per_people_f view on the effective_date

211: -- --
212: if (p_role_id is null) then
213: hr_utility.set_location(l_proc, 10);
214: --
215: -- Check that the person_id is in the per_people_f view on the effective_date
216: --
217: open csr_person_id;
218: fetch csr_person_id into l_dummy;
219: if csr_person_id%notfound then