APPS.BEN_PBN_BUS dependencies on BEN_OPT_F

Line 200: l_bnf_enrt_option_name ben_opt_f.name%TYPE;

196: l_bnf_mn_dsgntbl_pct_val number(15);
197: l_bnf_pct_incrmt_val number(15);
198: -- Added for Bug 2395217
199: l_bnf_enrt_oipl_id number(15);
200: l_bnf_enrt_option_name ben_opt_f.name%TYPE;
201: -- Added for bug no 1845251
202: l_pl_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683
203: --
204: cursor pl1(l_lf_evt_ocrd_dt date) is

Line 233: ben_opt_f opt

229: CURSOR csr_option_name(l_lf_evt_ocrd_dt date) is
230: SELECT
231: opt.NAME
232: FROM
233: ben_opt_f opt
234: ,ben_oipl_f oipl
235: WHERE
236: oipl.oipl_id=l_bnf_enrt_oipl_id
237: and nvl(l_lf_evt_ocrd_dt,p_effective_date) between oipl.effective_start_date and oipl.effective_end_date

Line 356: -- raise error as corresponding option does not exist in ben_opt_f

352: open csr_option_name(l_lf_evt_ocrd_dt);
353: fetch csr_option_name into l_bnf_enrt_option_name;
354: if csr_option_name%notfound then
355: close csr_option_name;
356: -- raise error as corresponding option does not exist in ben_opt_f
357: fnd_message.set_name('ben', 'ben_91641_enrt_rslt_invld');
358: fnd_message.raise_error;
359: end if;
360: close csr_option_name;

Line 395: -- raise error as corresponding option does not exist in ben_opt_f

391: open csr_option_name(l_lf_evt_ocrd_dt);
392: fetch csr_option_name into l_bnf_enrt_option_name;
393: if csr_option_name%notfound then
394: close csr_option_name;
395: -- raise error as corresponding option does not exist in ben_opt_f
396: fnd_message.set_name('ben', 'ben_91641_enrt_rslt_invld');
397: fnd_message.raise_error;
398: end if;
399: close csr_option_name;

Line 997: , ben_opt_f opt

993: cursor c_opt_dsgn_rqmt is
994: select distinct drt.rlshp_typ_cd
995: from ben_dsgn_rqmt_rlshp_typ drt
996: , ben_dsgn_rqmt_f drm
997: , ben_opt_f opt
998: , ben_oipl_f oipl
999: , ben_prtt_enrt_rslt_f pen
1000: where drt.dsgn_rqmt_id = drm.dsgn_rqmt_id
1001: and drt.business_group_id = p_business_group_id

Line 1112: from ben_opt_f

1108: and p_effective_date between effective_start_date and effective_end_date ;
1109: --
1110: cursor c_opt_name (p_opt_id number) is
1111: select name
1112: from ben_opt_f
1113: where opt_id=p_opt_id
1114: and p_effective_date between effective_start_date and effective_end_date ;
1115: --
1116: l_pl_name ben_pl_f.name%TYPE;

Line 1117: l_opt_name ben_opt_f.name%TYPE;

1113: where opt_id=p_opt_id
1114: and p_effective_date between effective_start_date and effective_end_date ;
1115: --
1116: l_pl_name ben_pl_f.name%TYPE;
1117: l_opt_name ben_opt_f.name%TYPE;
1118: Begin
1119:
1120: open c_pl_oipl;
1121: fetch c_pl_oipl into l_pl_id, l_oipl_id;

Line 1377: , ben_opt_f opt

1373: and pcr.contact_type in
1374: (select distinct drt.rlshp_typ_cd
1375: from ben_dsgn_rqmt_rlshp_typ drt
1376: , ben_dsgn_rqmt_f drm
1377: , ben_opt_f opt
1378: , ben_oipl_f oipl
1379: , ben_prtt_enrt_rslt_f pen
1380: where drt.dsgn_rqmt_id = drm.dsgn_rqmt_id
1381: and drt.business_group_id = p_business_group_id