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_PLAN_BENEFICIARY_API dependencies on BEN_PER_IN_LER

Line 84: ben_per_in_ler pil

80: --
81: cursor c_pil is
82: select pil.per_in_ler_id
83: from ben_prtt_enrt_rslt_f pen ,
84: ben_per_in_ler pil
85: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
86: and pen.per_in_ler_id = pil.per_in_ler_id
87: and pen.prtt_enrt_rslt_stat_cd is null
88: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')

Line 1608: ben_per_in_ler pil

1604: select pbn.prmry_cntngnt_cd prmry_cntngnt_cd,
1605: sum(pbn.pct_dsgd_num) prcnt,
1606: sum(pbn.amt_dsgd_val) amount
1607: from ben_pl_bnf_f pbn,
1608: ben_per_in_ler pil
1609: where pbn.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
1610: and pbn.business_group_id = l_business_group_id
1611: -- and p_effective_date between pbn.effective_start_date and pbn.effective_end_date
1612: and p_effective_date >= pbn.effective_start_date