DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 164: From ben_prtt_enrt_rslt_f a

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