APPS.BEN_PEN_BUS dependencies on BEN_PL_TYP_F

Line 348: p_business_group_id ben_pl_typ_f.business_group_id%type,

344: type pl_table is table of g_c_pl%rowtype index by binary_integer;
345: g_pl_tbl pl_table;
346: g_pl_cnt integer := 0;
347: cursor g_c_pl_typ (p_effective_date date,
348: p_business_group_id ben_pl_typ_f.business_group_id%type,
349: p_pl_typ_id ben_pl_typ_f.pl_typ_id%type) is
350: select pl_typ_id, name,
351: mx_enrl_alwd_num,
352: mn_enrl_rqd_num,

Line 349: p_pl_typ_id ben_pl_typ_f.pl_typ_id%type) is

345: g_pl_tbl pl_table;
346: g_pl_cnt integer := 0;
347: cursor g_c_pl_typ (p_effective_date date,
348: p_business_group_id ben_pl_typ_f.business_group_id%type,
349: p_pl_typ_id ben_pl_typ_f.pl_typ_id%type) is
350: select pl_typ_id, name,
351: mx_enrl_alwd_num,
352: mn_enrl_rqd_num,
353: 0 tot_pl_enrld,

Line 357: from ben_pl_typ_f

353: 0 tot_pl_enrld,
354: 0.0 tot_cvg_amt,
355: 'N' dpnt_cvd_by_othr_apls_flag,
356: 0.0 tot_cvg_amt_no_interim
357: from ben_pl_typ_f
358: where pl_typ_id = p_pl_typ_id
359: and business_group_id = p_business_group_id
360: and p_effective_date between
361: effective_start_date and effective_end_date

Line 387: from ben_ptip_f ptip, ben_pl_typ_f plt

383: 0.0 tot_cvg_amt,
384: plt.name,
385: 'N' dpnt_cvd_by_othr_apls_flag,
386: 0.0 tot_cvg_amt_no_interim
387: from ben_ptip_f ptip, ben_pl_typ_f plt
388: where ptip.ptip_id = p_ptip_id
389: and ptip.pl_typ_id = plt.pl_typ_id
390: and ptip.business_group_id = p_business_group_id
391: and p_effective_date between