APPS.PER_ESA_BUS dependencies on PER_ALL_PEOPLE_F

Line 252: -- per_all_people_f

248: --
249: --
250: -- Description:
251: -- - Validates that the person_id and the party_id are matched in
252: -- per_all_people_f
253: -- and if person_id is not null and party_id is null, derive party_id
254: -- from per_all_people_f from person_id
255: --
256: -- Pre_conditions:

Line 254: -- from per_all_people_f from person_id

250: -- Description:
251: -- - Validates that the person_id and the party_id are matched in
252: -- per_all_people_f
253: -- and if person_id is not null and party_id is null, derive party_id
254: -- from per_all_people_f from person_id
255: --
256: -- Pre_conditions:
257: -- A valid business_group_id
258: --

Line 288: from per_all_people_f per

284: -- cursor to check that the party_id maches person_id
285: --
286: cursor csr_get_party_id is
287: select party_id
288: from per_all_people_f per
289: where per.person_id = p_rec.person_id
290: and p_effective_date
291: between per.effective_start_date
292: and nvl(per.effective_end_date,hr_api.g_eot);

Line 316: -- derive party_id from per_all_people_f using person_id

312: hr_utility.raise_error;
313: end if;
314: else
315: --
316: -- derive party_id from per_all_people_f using person_id
317: --
318: hr_utility.set_location(l_proc,50);
319: p_rec.party_id := l_party_id;
320: end if;

Line 712: from per_all_people_f per

708: -- Bug: 1664075 Starts here
709: --
710: cursor c4 is
711: select DATE_OF_BIRTH
712: from per_all_people_f per
713: where per.person_id = p_person_id
714: and p_effective_date
715: between per.effective_start_date
716: and nvl(per.effective_end_date,hr_api.g_eot)