APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_PL_F

Line 1162: ,ben_pl_f pln

1158: --
1159: cursor c_chk_enrld is
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

Line 3676: from ben_pl_f pln

3672: cursor c_pln_name(c_pl_id in number
3673: ,c_effective_date in date )
3674: is
3675: select pln.name
3676: from ben_pl_f pln
3677: where pln.pl_id = c_pl_id
3678: and c_effective_date between pln.effective_start_date
3679: and pln.effective_end_date;
3680:

Line 3694: l_pln_name ben_pl_f.name%type;

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

Line 4128: FROM ben_pl_f pln

4124:
4125: CURSOR c_get_cbr_due_day(c_pl_id number
4126: ,c_effective_date date) IS
4127: SELECT NVL(pln.cobra_pymt_due_dy_num,1)
4128: FROM ben_pl_f pln
4129: WHERE pln.pl_id = c_pl_id
4130: AND c_effective_date BETWEEN pln.effective_start_date
4131: AND pln.effective_end_date;
4132:

Line 4344: l_pl_id ben_pl_f.pl_id%type;

4340: l_ovn number;
4341: l_warning boolean;
4342:
4343: l_amount_paid_bal number;
4344: l_pl_id ben_pl_f.pl_id%type;
4345: l_cbr_due_day ben_pl_f.cobra_pymt_due_dy_num%type;
4346:
4347: l_amount_due number;
4348:

Line 4345: l_cbr_due_day ben_pl_f.cobra_pymt_due_dy_num%type;

4341: l_warning boolean;
4342:
4343: l_amount_paid_bal number;
4344: l_pl_id ben_pl_f.pl_id%type;
4345: l_cbr_due_day ben_pl_f.cobra_pymt_due_dy_num%type;
4346:
4347: l_amount_due number;
4348:
4349: l_prev_pymts number;