APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_OIPL_F

Line 3076: from ben_oipl_f oipl

3072: l_proc varchar2(80) ;
3073: --
3074: cursor c_opt is
3075: select oipl.opt_id
3076: from ben_oipl_f oipl
3077: where oipl.oipl_id = p_oipl_id
3078: and business_group_id = p_business_group_id
3079: and p_effective_date between
3080: oipl.effective_start_date and oipl.effective_end_date;

Line 4698: ben_oipl_f cop,

4694: sum(tot_mx_dpnts_alwd_num) tot_mx_dpnts_alwd_num
4695: from (select sum(nvl(drq.mn_dpnts_rqd_num, 0 )) tot_mn_dpnts_rqd_num,
4696: sum(nvl(drq.mx_dpnts_alwd_num,9999999999)) tot_mx_dpnts_alwd_num
4697: from ben_dsgn_rqmt_f drq,
4698: ben_oipl_f cop,
4699: ben_prtt_enrt_rslt_f pen
4700: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4701: -- and drq.oipl_id = pen.oipl_id -- 3730053: OPT level DSGN_RQMTS override OIPL level
4702: and pen.oipl_id = cop.oipl_id

Line 4747: ben_oipl_f cop

4743: and p_effective_date between drq3.effective_start_date and drq3.effective_end_date
4744: UNION ALL
4745: select null
4746: from ben_dsgn_rqmt_f drq4,
4747: ben_oipl_f cop
4748: where cop.oipl_id = pen.oipl_id
4749: and drq4.opt_id = cop.opt_id
4750: and p_effective_date between cop.effective_start_date and cop.effective_end_date
4751: and p_effective_date between drq4.effective_start_date and drq4.effective_end_date))

Line 5078: from ben_oipl_f o

5074: or
5075: nvl(drq.oipl_id,0) = perslt.oipl_id
5076: or
5077: nvl(drq.opt_id,0) = (select o.opt_id
5078: from ben_oipl_f o
5079: where o.oipl_id = perslt.oipl_id
5080: and c_effective_date
5081: between o.effective_start_date
5082: and o.effective_end_date)

Line 5127: from ben_oipl_f o

5123: or
5124: nvl(drq.oipl_id,0) = perslt.oipl_id
5125: or
5126: nvl(drq.opt_id,0) = (select o.opt_id
5127: from ben_oipl_f o
5128: where o.oipl_id = perslt.oipl_id
5129: and c_effective_date
5130: between o.effective_start_date
5131: and o.effective_end_date)

Line 7039: ben_oipl_f cop

7035: select cop.pcp_dpnt_dsgn_cd,
7036: ecd.elig_cvrd_dpnt_id
7037: from ben_prtt_enrt_rslt_f pen,
7038: ben_elig_cvrd_dpnt_f ecd,
7039: ben_oipl_f cop
7040: where cop.oipl_id = pen.oipl_id
7041: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7042: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
7043: and ecd.cvg_strt_dt is not null

Line 7225: ben_oipl_f cop

7221:
7222: cursor c_pcp_cd_oipl is
7223: select cop.pcp_dsgn_cd
7224: from ben_prtt_enrt_rslt_f perf,
7225: ben_oipl_f cop
7226: where cop.oipl_id = perf.oipl_id
7227: and perf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7228: and perf.business_group_id = p_business_group_id
7229: and cop.business_group_id = p_business_group_id

Line 7741: FROM ben_oipl_f oipl

7737: asg_rec c_asg%ROWTYPE;
7738: --
7739: cursor c_opt (v_oipl_id in number) is
7740: SELECT opt_id
7741: FROM ben_oipl_f oipl
7742: WHERE oipl.oipl_id = v_oipl_id
7743: AND oipl.business_group_id = p_business_group_id
7744: AND p_effective_date BETWEEN oipl.effective_start_date
7745: AND oipl.effective_end_date;

Line 8757: from ben_oipl_f oipl

8753: l_rslt c_rslt%rowtype;
8754:
8755: cursor c_opt is
8756: select oipl.opt_id
8757: from ben_oipl_f oipl
8758: where oipl.oipl_id = l_rslt.oipl_id
8759: and business_group_id = p_business_group_id
8760: and p_effective_date between
8761: oipl.effective_start_date and oipl.effective_end_date;

Line 9397: l_oipl_id ben_oipl_f.oipl_id%type;

9393: -- Bug : 1857685
9394: --
9395: l_waive_flag varchar2(2) := 'N';
9396: l_pl_id ben_pl_f.pl_id%type;
9397: l_oipl_id ben_oipl_f.oipl_id%type;
9398: l_comp_lvl_cd ben_prtt_enrt_rslt_f.comp_lvl_cd%type;
9399:
9400: --
9401: cursor c_waive_info_flag is

Line 9424: ben_oipl_f oipl

9420: --
9421: cursor c_waive_opt_flag is
9422: select invk_wv_opt_flag
9423: from ben_opt_f opt,
9424: ben_oipl_f oipl
9425: where opt.opt_id = oipl.opt_id
9426: and oipl.oipl_id = l_oipl_id
9427: and p_effective_date between
9428: opt.effective_start_date and opt.effective_end_date