APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_OIPL_F

Line 3063: from ben_oipl_f oipl

3059: l_proc varchar2(80) ;
3060: --
3061: cursor c_opt is
3062: select oipl.opt_id
3063: from ben_oipl_f oipl
3064: where oipl.oipl_id = p_oipl_id
3065: and business_group_id = p_business_group_id
3066: and p_effective_date between
3067: oipl.effective_start_date and oipl.effective_end_date;

Line 4685: ben_oipl_f cop,

4681: sum(tot_mx_dpnts_alwd_num) tot_mx_dpnts_alwd_num
4682: from (select sum(nvl(drq.mn_dpnts_rqd_num, 0 )) tot_mn_dpnts_rqd_num,
4683: sum(nvl(drq.mx_dpnts_alwd_num,9999999999)) tot_mx_dpnts_alwd_num
4684: from ben_dsgn_rqmt_f drq,
4685: ben_oipl_f cop,
4686: ben_prtt_enrt_rslt_f pen
4687: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4688: -- and drq.oipl_id = pen.oipl_id -- 3730053: OPT level DSGN_RQMTS override OIPL level
4689: and pen.oipl_id = cop.oipl_id

Line 4734: ben_oipl_f cop

4730: and p_effective_date between drq3.effective_start_date and drq3.effective_end_date
4731: UNION ALL
4732: select null
4733: from ben_dsgn_rqmt_f drq4,
4734: ben_oipl_f cop
4735: where cop.oipl_id = pen.oipl_id
4736: and drq4.opt_id = cop.opt_id
4737: and p_effective_date between cop.effective_start_date and cop.effective_end_date
4738: and p_effective_date between drq4.effective_start_date and drq4.effective_end_date))

Line 5064: from ben_oipl_f o

5060: or
5061: nvl(drq.oipl_id,0) = perslt.oipl_id
5062: or
5063: nvl(drq.opt_id,0) = (select o.opt_id
5064: from ben_oipl_f o
5065: where o.oipl_id = perslt.oipl_id
5066: and p_effective_date
5067: between o.effective_start_date
5068: and o.effective_end_date)

Line 5112: from ben_oipl_f o

5108: or
5109: nvl(drq.oipl_id,0) = perslt.oipl_id
5110: or
5111: nvl(drq.opt_id,0) = (select o.opt_id
5112: from ben_oipl_f o
5113: where o.oipl_id = perslt.oipl_id
5114: and p_effective_date
5115: between o.effective_start_date
5116: and o.effective_end_date)

Line 6954: ben_oipl_f cop

6950: select cop.pcp_dpnt_dsgn_cd,
6951: ecd.elig_cvrd_dpnt_id
6952: from ben_prtt_enrt_rslt_f pen,
6953: ben_elig_cvrd_dpnt_f ecd,
6954: ben_oipl_f cop
6955: where cop.oipl_id = pen.oipl_id
6956: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6957: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
6958: and ecd.cvg_strt_dt is not null

Line 7140: ben_oipl_f cop

7136:
7137: cursor c_pcp_cd_oipl is
7138: select cop.pcp_dsgn_cd
7139: from ben_prtt_enrt_rslt_f perf,
7140: ben_oipl_f cop
7141: where cop.oipl_id = perf.oipl_id
7142: and perf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7143: and perf.business_group_id = p_business_group_id
7144: and cop.business_group_id = p_business_group_id

Line 7656: FROM ben_oipl_f oipl

7652: asg_rec c_asg%ROWTYPE;
7653: --
7654: cursor c_opt (v_oipl_id in number) is
7655: SELECT opt_id
7656: FROM ben_oipl_f oipl
7657: WHERE oipl.oipl_id = v_oipl_id
7658: AND oipl.business_group_id = p_business_group_id
7659: AND p_effective_date BETWEEN oipl.effective_start_date
7660: AND oipl.effective_end_date;

Line 8672: from ben_oipl_f oipl

8668: l_rslt c_rslt%rowtype;
8669:
8670: cursor c_opt is
8671: select oipl.opt_id
8672: from ben_oipl_f oipl
8673: where oipl.oipl_id = l_rslt.oipl_id
8674: and business_group_id = p_business_group_id
8675: and p_effective_date between
8676: oipl.effective_start_date and oipl.effective_end_date;

Line 9312: l_oipl_id ben_oipl_f.oipl_id%type;

9308: -- Bug : 1857685
9309: --
9310: l_waive_flag varchar2(2) := 'N';
9311: l_pl_id ben_pl_f.pl_id%type;
9312: l_oipl_id ben_oipl_f.oipl_id%type;
9313: l_comp_lvl_cd ben_prtt_enrt_rslt_f.comp_lvl_cd%type;
9314:
9315: --
9316: cursor c_waive_info_flag is

Line 9339: ben_oipl_f oipl

9335: --
9336: cursor c_waive_opt_flag is
9337: select invk_wv_opt_flag
9338: from ben_opt_f opt,
9339: ben_oipl_f oipl
9340: where opt.opt_id = oipl.opt_id
9341: and oipl.oipl_id = l_oipl_id
9342: and p_effective_date between
9343: opt.effective_start_date and opt.effective_end_date