APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_OIPL_F

Line 1163: ,ben_oipl_f cop

1159: cursor c_chk_enrld is
1160: select null
1161: from ben_prtt_enrt_rslt_f pen
1162: ,ben_pl_f pln
1163: ,ben_oipl_f cop
1164: ,ben_opt_f opt
1165: where pen.person_id = p_person_id
1166: and pen.prtt_enrt_rslt_stat_cd is null
1167: and pen.pgm_id = nvl(p_pgm_id, pen.pgm_id)

Line 3185: ben_oipl_f opt

3181: pen.person_id,
3182: pen.effective_start_date,
3183: pen.effective_end_date
3184: from ben_prtt_enrt_rslt_f pen,
3185: ben_oipl_f opt
3186: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3187: and opt.oipl_id(+)=pen.oipl_id
3188: and pen.prtt_enrt_rslt_stat_cd is null
3189: and pen.enrt_cvg_strt_dt between opt.effective_start_date(+)

Line 3685: from ben_oipl_f cop,

3681: cursor c_opt_name(c_oipl_id in number
3682: ,c_effective_date in date )
3683: is
3684: select opt.name
3685: from ben_oipl_f cop,
3686: ben_opt_f opt
3687: where cop.oipl_id = c_oipl_id
3688: and cop.opt_id = opt.opt_id
3689: and c_effective_date between cop.effective_start_date