APPS.BEN_PEN_BUS dependencies on BEN_PTIP_F

Line 367: p_business_group_id ben_ptip_f.business_group_id%type,

363: type pl_typ_table is table of g_c_pl_typ%rowtype index by binary_integer;
364: g_pl_typ_tbl pl_typ_table;
365: g_pl_typ_cnt integer := 0;
366: cursor g_c_ptip(p_effective_date date,
367: p_business_group_id ben_ptip_f.business_group_id%type,
368: p_ptip_id ben_ptip_f.ptip_id%type
369: ) is
370: select ptip.ptip_id,
371: ptip.pgm_id,

Line 368: p_ptip_id ben_ptip_f.ptip_id%type

364: g_pl_typ_tbl pl_typ_table;
365: g_pl_typ_cnt integer := 0;
366: cursor g_c_ptip(p_effective_date date,
367: p_business_group_id ben_ptip_f.business_group_id%type,
368: p_ptip_id ben_ptip_f.ptip_id%type
369: ) is
370: select ptip.ptip_id,
371: ptip.pgm_id,
372: ptip.pl_typ_id,

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