DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 168: From ben_prtt_enrt_rslt_f a

164: Cursor c1 is
165: Select a.pgm_id, a.pl_typ_id, a.pl_id, a.oipl_id, b.opt_id
166: ,a.bnft_amt, a.uom
167: ,a.enrt_cvg_strt_dt, a.enrt_cvg_thru_dt
168: From ben_prtt_enrt_rslt_f a
169: ,ben_oipl_f b
170: Where a.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
171: and a.prtt_enrt_rslt_stat_cd is null
172: and p_effective_date between