DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS2 dependencies on BEN_PLIP_F

Line 320: FROM ben_prtt_enrt_rslt_f pen, ben_plip_f plip

316: IS
317: SELECT pen.pl_id,
318: pen.oipl_id,
319: plip.plip_id
320: FROM ben_prtt_enrt_rslt_f pen, ben_plip_f plip
321: WHERE pen.person_id = c_per_id
322: AND pen.business_group_id = c_bgp_id
323: AND pen.prtt_enrt_rslt_stat_cd IS NULL
324: --AND pen.sspndd_flag = 'N'