APPS.BEN_PEN_BUS dependencies on BEN_PL_TYP_F

Line 336: p_business_group_id ben_pl_typ_f.business_group_id%type,

332: type pl_table is table of g_c_pl%rowtype index by binary_integer;
333: g_pl_tbl pl_table;
334: g_pl_cnt integer := 0;
335: cursor g_c_pl_typ (p_effective_date date,
336: p_business_group_id ben_pl_typ_f.business_group_id%type,
337: p_pl_typ_id ben_pl_typ_f.pl_typ_id%type) is
338: select pl_typ_id, name,
339: mx_enrl_alwd_num,
340: mn_enrl_rqd_num,

Line 337: p_pl_typ_id ben_pl_typ_f.pl_typ_id%type) is

333: g_pl_tbl pl_table;
334: g_pl_cnt integer := 0;
335: cursor g_c_pl_typ (p_effective_date date,
336: p_business_group_id ben_pl_typ_f.business_group_id%type,
337: p_pl_typ_id ben_pl_typ_f.pl_typ_id%type) is
338: select pl_typ_id, name,
339: mx_enrl_alwd_num,
340: mn_enrl_rqd_num,
341: 0 tot_pl_enrld,

Line 345: from ben_pl_typ_f

341: 0 tot_pl_enrld,
342: 0.0 tot_cvg_amt,
343: 'N' dpnt_cvd_by_othr_apls_flag,
344: 0.0 tot_cvg_amt_no_interim
345: from ben_pl_typ_f
346: where pl_typ_id = p_pl_typ_id
347: and business_group_id = p_business_group_id
348: and p_effective_date between
349: effective_start_date and effective_end_date

Line 375: from ben_ptip_f ptip, ben_pl_typ_f plt

371: 0.0 tot_cvg_amt,
372: plt.name,
373: 'N' dpnt_cvd_by_othr_apls_flag,
374: 0.0 tot_cvg_amt_no_interim
375: from ben_ptip_f ptip, ben_pl_typ_f plt
376: where ptip.ptip_id = p_ptip_id
377: and ptip.pl_typ_id = plt.pl_typ_id
378: and ptip.business_group_id = p_business_group_id
379: and p_effective_date between