APPS.BEN_PEN_BUS dependencies on BEN_PL_F

Line 47: ben_pl_f pln

43: /* End Bug#: 3255596: change */
44: /*
45: ,
46: ben_oipl_f cop,
47: ben_pl_f pln
48: */
49: where pen.person_id = c_person_id
50: and pen.prtt_enrt_rslt_stat_cd is null
51: and nvl(pen.pgm_id,-999999) = c_pgm_id

Line 214: ben_pl_f pln

210: cop.opt_id
211: from ben_prtt_enrt_rslt_f pen,
212: ben_elig_per_elctbl_chc epe,
213: ben_oipl_f cop,
214: ben_pl_f pln
215: where pen.person_id = p_person_id
216: and pen.prtt_enrt_rslt_stat_cd is null
217: and nvl(pen.pgm_id,-999999) = nvl(p_pgm_id, -999999)
218: */

Line 307: ,p_business_group_id ben_pl_f.business_group_id%type

303: g_enrt_tbl enrt_table;
304: g_comp_obj_cnt integer := 0;
305: --
306: cursor g_c_pl (p_effective_date date
307: ,p_business_group_id ben_pl_f.business_group_id%type
308: ,p_pl_id ben_pl_f.pl_typ_id%type
309: ) is
310: select pl_id,
311: name,

Line 308: ,p_pl_id ben_pl_f.pl_typ_id%type

304: g_comp_obj_cnt integer := 0;
305: --
306: cursor g_c_pl (p_effective_date date
307: ,p_business_group_id ben_pl_f.business_group_id%type
308: ,p_pl_id ben_pl_f.pl_typ_id%type
309: ) is
310: select pl_id,
311: name,
312: pl_typ_id,

Line 326: from ben_pl_f

322: 0 tot_opt_enrld,
323: 0.0 tot_cvg_amt,
324: 0.0 prev_cvg_amt,
325: 0.0 tot_cvg_amt_no_interim
326: from ben_pl_f
327: where pl_id = p_pl_id and
328: business_group_id = p_business_group_id and
329: p_effective_date between
330: effective_start_date and effective_end_date