APPS.BEN_PBN_BUS dependencies on BEN_PL_F

Line 202: l_pl_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683

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
205: select a.bnf_dsgn_cd
206: -- added for bug no. 1845251

Line 217: from ben_pl_f a

213: , a.bnf_incrmt_amt
214: , a.bnf_mn_dsgntbl_pct_val
215: , a.bnf_pct_incrmt_val
216: , b.oipl_id
217: from ben_pl_f a
218: , ben_prtt_enrt_rslt_f b
219: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
220: and b.prtt_enrt_rslt_stat_cd is null
221: and nvl(l_lf_evt_ocrd_dt,p_effective_date) between b.effective_start_date

Line 269: -- check if ben_pl_f bnf parameters do not contradict ben_pl_bnf_f values

265: hr_utility.set_location('l_lf_evt_ocrd_dt :' || l_lf_evt_ocrd_dt, 12345);
266: close c_pil;
267: end if;
268:
269: -- check if ben_pl_f bnf parameters do not contradict ben_pl_bnf_f values
270: open pl1(l_lf_evt_ocrd_dt);
271:
272: fetch pl1 into
273: l_bnf_dsgn_cd

Line 287: -- raise error as corresponding Plan does not exist in ben_pl_f

283: ,l_bnf_enrt_oipl_id
284: ;
285: if pl1%notfound then
286: close pl1;
287: -- raise error as corresponding Plan does not exist in ben_pl_f
288: -- table.
289: fnd_message.set_name('BEN', 'BEN_91641_ENRT_RSLT_INVLD');
290: fnd_message.raise_error;
291: elsif l_bnf_dsgn_cd is null then

Line 1041: , ben_pl_f pln

1037: cursor c_pl_dsgn_rqmt is
1038: select distinct drt.rlshp_typ_cd
1039: from ben_dsgn_rqmt_rlshp_typ drt
1040: , ben_dsgn_rqmt_f drm
1041: , ben_pl_f pln
1042: , ben_prtt_enrt_rslt_f pen
1043: where drt.dsgn_rqmt_id = drm.dsgn_rqmt_id
1044: and drt.business_group_id = p_business_group_id
1045: and drm.dsgn_typ_cd = 'BNF'

Line 1106: from ben_pl_f

1102: Procedure raise_error is
1103: --
1104: cursor c_pl_name (p_pl_id number) is
1105: select name
1106: from ben_pl_f
1107: where pl_id=p_pl_id
1108: and p_effective_date between effective_start_date and effective_end_date ;
1109: --
1110: cursor c_opt_name (p_opt_id number) is

Line 1116: l_pl_name ben_pl_f.name%TYPE;

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;
1117: l_opt_name ben_opt_f.name%TYPE;
1118: Begin
1119:
1120: open c_pl_oipl;

Line 1443: , ben_pl_f pln

1439: and pcr.contact_type in
1440: (select distinct drt.rlshp_typ_cd
1441: from ben_dsgn_rqmt_rlshp_typ drt
1442: , ben_dsgn_rqmt_f drm
1443: , ben_pl_f pln
1444: , ben_prtt_enrt_rslt_f pen
1445: where drt.dsgn_rqmt_id = drm.dsgn_rqmt_id
1446: and drt.business_group_id = p_business_group_id
1447: and drm.dsgn_typ_cd = 'BNF'