APPS.PER_QUA_BUS dependencies on PER_ALL_PEOPLE_F

Line 334: from per_all_people_f per -- Bug 3148893. Replaced per_all_people_f with per_people_f

330: l_dummy varchar2(1);
331: --
332: cursor c1 is
333: select null
334: from per_all_people_f per -- Bug 3148893. Replaced per_all_people_f with per_people_f
335: where per.person_id = p_person_id
336: and p_effective_date
337: between per.effective_start_date
338: and nvl(per.effective_end_date,hr_api.g_eot);

Line 445: -- per_all_people_f

441: --
442: --
443: -- Description:
444: -- - Validates that the person_id and the party_id are matched in
445: -- per_all_people_f
446: -- and if person_id is not null and party_id is null, derive party_id
447: -- from per_all_people_f from person_id
448: --
449: -- Pre_conditions:

Line 447: -- from per_all_people_f from person_id

443: -- Description:
444: -- - Validates that the person_id and the party_id are matched in
445: -- per_all_people_f
446: -- and if person_id is not null and party_id is null, derive party_id
447: -- from per_all_people_f from person_id
448: --
449: -- Pre_conditions:
450: -- A valid business_group_id
451: --

Line 482: from per_all_people_f per

478: -- cursor to check that the party_id maches person_id
479: --
480: cursor csr_get_party_id is
481: select party_id
482: from per_all_people_f per
483: where per.person_id = p_rec.person_id
484: and p_effective_date
485: between per.effective_start_date
486: and nvl(per.effective_end_date,hr_api.g_eot);

Line 523: -- derive party_id from per_all_people_f using person_id

519: );
520: end if;
521: else
522: --
523: -- derive party_id from per_all_people_f using person_id
524: --
525: hr_utility.set_location(l_proc,50);
526: p_rec.party_id := l_party_id;
527: end if;

Line 1050: from per_all_people_f per

1046: -- Bug: 1664055 Starts here.
1047: --
1048: cursor c3 is
1049: select DATE_OF_BIRTH
1050: from per_all_people_f per
1051: where per.person_id = p_person_id
1052: and p_effective_date
1053: between per.effective_start_date
1054: and nvl(per.effective_end_date,hr_api.g_eot)

Line 1582: from per_all_people_f per -- Bug 3148893. Replaced per_all_people_f with per_people_f

1578: l_dummy varchar2(1);
1579: --
1580: cursor c1 is
1581: select null
1582: from per_all_people_f per -- Bug 3148893. Replaced per_all_people_f with per_people_f
1583: where per.person_id = p_person_id
1584: and per.business_group_id +0 = nvl(p_business_group_id,
1585: per.business_group_id)
1586: and p_effective_date