APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_OPT_F

Line 1164: ,ben_opt_f opt

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

Line 3686: ben_opt_f opt

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

Line 3695: l_opt_name ben_opt_f.name%type;

3691: and c_effective_date between opt.effective_start_date
3692: and opt.effective_end_date;
3693:
3694: l_pln_name ben_pl_f.name%type;
3695: l_opt_name ben_opt_f.name%type;
3696: l_comp_object_name varchar2(500);
3697:
3698: begin
3699: open c_pln_name(p_pl_id,p_effective_date);