DBA Data[Home] [Help]

APPS.BEN_PEN_BUS dependencies on PER_ALL_PEOPLE_F

Line 904: per_all_people_f per,

900: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
901: cvr.person_id, bpl.NAME, crt.crt_ordr_typ_cd
902: FROM ben_crt_ordr crt,
903: ben_crt_ordr_cvrd_per cvr,
904: per_all_people_f per,
905: per_contact_relationships con,
906: hr_lookups lkp,
907: ben_pl_f bpl
908: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')

Line 950: per_all_people_f per,

946: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
947: cvr.person_id, bpt.NAME, crt.crt_ordr_typ_cd
948: FROM ben_crt_ordr crt,
949: ben_crt_ordr_cvrd_per cvr,
950: per_all_people_f per,
951: per_contact_relationships con,
952: hr_lookups lkp,
953: ben_pl_typ_f bpt
954: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')