APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_PL_F

Line 1180: ,ben_pl_f pln

1176: --
1177: cursor c_chk_enrld is
1178: select null
1179: from ben_prtt_enrt_rslt_f pen
1180: ,ben_pl_f pln
1181: ,ben_oipl_f cop
1182: ,ben_opt_f opt
1183: where pen.person_id = p_person_id
1184: and pen.prtt_enrt_rslt_stat_cd is null

Line 4035: from ben_pl_f pln

4031: cursor c_pln_name(c_pl_id in number
4032: ,c_effective_date in date )
4033: is
4034: select pln.name
4035: from ben_pl_f pln
4036: where pln.pl_id = c_pl_id
4037: and c_effective_date between pln.effective_start_date
4038: and pln.effective_end_date;
4039:

Line 4053: l_pln_name ben_pl_f.name%type;

4049: and cop.effective_end_date
4050: and c_effective_date between opt.effective_start_date
4051: and opt.effective_end_date;
4052:
4053: l_pln_name ben_pl_f.name%type;
4054: l_opt_name ben_opt_f.name%type;
4055: l_comp_object_name varchar2(500);
4056:
4057: begin

Line 4487: FROM ben_pl_f pln

4483:
4484: CURSOR c_get_cbr_due_day(c_pl_id number
4485: ,c_effective_date date) IS
4486: SELECT NVL(pln.cobra_pymt_due_dy_num,1)
4487: FROM ben_pl_f pln
4488: WHERE pln.pl_id = c_pl_id
4489: AND c_effective_date BETWEEN pln.effective_start_date
4490: AND pln.effective_end_date;
4491:

Line 4703: l_pl_id ben_pl_f.pl_id%type;

4699: l_ovn number;
4700: l_warning boolean;
4701:
4702: l_amount_paid_bal number;
4703: l_pl_id ben_pl_f.pl_id%type;
4704: l_cbr_due_day ben_pl_f.cobra_pymt_due_dy_num%type;
4705:
4706: l_amount_due number;
4707:

Line 4704: l_cbr_due_day ben_pl_f.cobra_pymt_due_dy_num%type;

4700: l_warning boolean;
4701:
4702: l_amount_paid_bal number;
4703: l_pl_id ben_pl_f.pl_id%type;
4704: l_cbr_due_day ben_pl_f.cobra_pymt_due_dy_num%type;
4705:
4706: l_amount_due number;
4707:
4708: l_prev_pymts number;