APPS.PER_ADD_BUS dependencies on PER_ALL_PEOPLE_F

Line 165: from per_all_people_f ppf

161: l_business_group_id number;
162: --
163: cursor csr_valid_pers is
164: select business_group_id
165: from per_all_people_f ppf
166: where ppf.person_id = p_person_id;
167: --
168: begin
169: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 305: from per_all_people_f per

301: -- cursor to check that the party_id matches person_id
302: --
303: cursor csr_get_party_id is
304: select party_id
305: from per_all_people_f per
306: where per.person_id = p_rec.person_id
307: and p_rec.date_from
308: between per.effective_start_date
309: and nvl(per.effective_end_date,hr_api.g_eot);

Line 342: -- derive party_id from per_all_people_f using person_id

338: );
339: end if;
340: else
341: --
342: -- derive party_id from per_all_people_f using person_id
343: --
344: hr_utility.set_location(l_proc,50);
345: p_rec.party_id := l_party_id;
346: end if;