APPS.BEN_PDP_BUS dependencies on PER_ALL_PEOPLE_F

Line 318: from per_all_people_f a

314: ;
315: --
316: cursor c1 is
317: select null
318: from per_all_people_f a
319: where a.person_id = p_dpnt_person_id
320: and a.business_group_id + 0 = p_business_group_id
321: and p_validation_start_date <= effective_end_date
322: and p_validation_end_date >= effective_start_date

Line 339: -- check if dpnt_person_id value exists in per_all_people_f table

335: and nvl(p_dpnt_person_id,hr_api.g_number)
336: <> nvl(ben_pdp_shd.g_old_rec.dpnt_person_id, hr_api.g_number)
337: or not l_api_updating) then
338: --
339: -- check if dpnt_person_id value exists in per_all_people_f table
340: --
341: open c1;
342: --
343: fetch c1 into l_dummy;

Line 920: per_all_people_f per,

916: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
917: cvr.person_id, bpl.NAME, crt.CRT_ORDR_TYP_CD
918: FROM ben_crt_ordr crt,
919: ben_crt_ordr_cvrd_per cvr,
920: per_all_people_f per,
921: per_contact_relationships con,
922: hr_lookups lkp,
923: ben_pl_f bpl
924: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')

Line 967: per_all_people_f per,

963: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
964: cvr.person_id, bpt.NAME, crt.CRT_ORDR_TYP_CD
965: FROM ben_crt_ordr crt,
966: ben_crt_ordr_cvrd_per cvr,
967: per_all_people_f per,
968: per_contact_relationships con,
969: hr_lookups lkp,
970: ben_pl_typ_f bpt
971: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')