APPS.BEN_PEN_BUS dependencies on BEN_PL_F

Line 48: ben_pl_f pln

44: /* End Bug#: 3255596: change */
45: /*
46: ,
47: ben_oipl_f cop,
48: ben_pl_f pln
49: */
50: where pen.person_id = c_person_id
51: and pen.ler_id = ler.ler_id
52: and c_effective_date between ler.effective_start_date and ler.effective_end_date

Line 226: ben_pl_f pln

222: cop.opt_id
223: from ben_prtt_enrt_rslt_f pen,
224: ben_elig_per_elctbl_chc epe,
225: ben_oipl_f cop,
226: ben_pl_f pln
227: where pen.person_id = p_person_id
228: and pen.prtt_enrt_rslt_stat_cd is null
229: and nvl(pen.pgm_id,-999999) = nvl(p_pgm_id, -999999)
230: */

Line 319: ,p_business_group_id ben_pl_f.business_group_id%type

315: g_enrt_tbl enrt_table;
316: g_comp_obj_cnt integer := 0;
317: --
318: cursor g_c_pl (p_effective_date date
319: ,p_business_group_id ben_pl_f.business_group_id%type
320: ,p_pl_id ben_pl_f.pl_typ_id%type
321: ) is
322: select pl_id,
323: name,

Line 320: ,p_pl_id ben_pl_f.pl_typ_id%type

316: g_comp_obj_cnt integer := 0;
317: --
318: cursor g_c_pl (p_effective_date date
319: ,p_business_group_id ben_pl_f.business_group_id%type
320: ,p_pl_id ben_pl_f.pl_typ_id%type
321: ) is
322: select pl_id,
323: name,
324: pl_typ_id,

Line 338: from ben_pl_f

334: 0 tot_opt_enrld,
335: 0.0 tot_cvg_amt,
336: 0.0 prev_cvg_amt,
337: 0.0 tot_cvg_amt_no_interim
338: from ben_pl_f
339: where pl_id = p_pl_id and
340: business_group_id = p_business_group_id and
341: p_effective_date between
342: effective_start_date and effective_end_date