APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_OPT_F

Line 1182: ,ben_opt_f opt

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)
1186: -- and pen.ptip_id = nvl(p_ptip_id, pen.ptip_id)

Line 4045: ben_opt_f opt

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
4049: and cop.effective_end_date

Line 4054: l_opt_name ben_opt_f.name%type;

4050: and c_effective_date between opt.effective_start_date
4051: and opt.effective_end_date;
4052:
4053: l_pln_name ben_pl_f.name%type;
4054: l_opt_name ben_opt_f.name%type;
4055: l_comp_object_name varchar2(500);
4056:
4057: begin
4058: open c_pln_name(p_pl_id,p_effective_date);