APPS.BEN_PBN_BUS dependencies on PER_ALL_PEOPLE_F

Line 784: from per_all_people_f a

780: --
781: --
782: cursor c1 is
783: select null
784: from per_all_people_f a
785: where a.person_id = p_bnf_person_id
786: and a.business_group_id + 0 = p_business_group_id
787: and p_validation_start_date <= effective_end_date
788: and p_validation_end_date >= effective_start_date

Line 806: -- check if bnf_person_id value exists in per_all_people_f table

802: and nvl(p_bnf_person_id,hr_api.g_number)
803: <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)
804: or not l_api_updating) then
805: --
806: -- check if bnf_person_id value exists in per_all_people_f table
807: --
808: open c1;
809: --
810: fetch c1 into l_dummy;

Line 914: -- check if ttee_person_id value exists in per_all_people_f table

910: and nvl(p_ttee_person_id,hr_api.g_number)
911: <> nvl(ben_pbn_shd.g_old_rec.ttee_person_id, hr_api.g_number)
912: or not l_api_updating) then
913: --
914: -- check if ttee_person_id value exists in per_all_people_f table
915: --
916: open c1;
917: --
918: fetch c1 into l_dummy;