eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PEN_BUS dependencies on BEN_PTIP_F

Line 355: p_business_group_id ben_ptip_f.business_group_id%type,

351: type pl_typ_table is table of g_c_pl_typ%rowtype index by binary_integer;
352: g_pl_typ_tbl pl_typ_table;
353: g_pl_typ_cnt integer := 0;
354: cursor g_c_ptip(p_effective_date date,
355: p_business_group_id ben_ptip_f.business_group_id%type,
356: p_ptip_id ben_ptip_f.ptip_id%type
357: ) is
358: select ptip.ptip_id,
359: ptip.pgm_id,

Line 356: p_ptip_id ben_ptip_f.ptip_id%type

352: g_pl_typ_tbl pl_typ_table;
353: g_pl_typ_cnt integer := 0;
354: cursor g_c_ptip(p_effective_date date,
355: p_business_group_id ben_ptip_f.business_group_id%type,
356: p_ptip_id ben_ptip_f.ptip_id%type
357: ) is
358: select ptip.ptip_id,
359: ptip.pgm_id,
360: ptip.pl_typ_id,

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