APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_OIPL_F

Line 1181: ,ben_oipl_f cop

1177: cursor c_chk_enrld is
1178: select null
1179: from ben_prtt_enrt_rslt_f pen
1180: ,ben_pl_f pln
1181: ,ben_oipl_f cop
1182: ,ben_opt_f opt
1183: where pen.person_id = p_person_id
1184: and pen.prtt_enrt_rslt_stat_cd is null
1185: and pen.pgm_id = nvl(p_pgm_id, pen.pgm_id)

Line 3544: ben_oipl_f opt

3540: pen.person_id,
3541: pen.effective_start_date,
3542: pen.effective_end_date
3543: from ben_prtt_enrt_rslt_f pen,
3544: ben_oipl_f opt
3545: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3546: and opt.oipl_id(+)=pen.oipl_id
3547: and pen.prtt_enrt_rslt_stat_cd is null
3548: and pen.enrt_cvg_strt_dt between opt.effective_start_date(+)

Line 4044: from ben_oipl_f cop,

4040: cursor c_opt_name(c_oipl_id in number
4041: ,c_effective_date in date )
4042: is
4043: select opt.name
4044: from ben_oipl_f cop,
4045: ben_opt_f opt
4046: where cop.oipl_id = c_oipl_id
4047: and cop.opt_id = opt.opt_id
4048: and c_effective_date between cop.effective_start_date