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_DETERMINE_RATES dependencies on BEN_ENRT_BNFT

Line 375: ben_enrt_bnft enb

371: --
372: cursor c_prtt_enrt_rslt (c_prtt_enrt_rslt_id number) is
373: select null
374: from ben_prtt_enrt_rslt_f pen,
375: ben_enrt_bnft enb
376: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
377: and pen.bnft_ordr_num = enb.ordr_num
378: and enb.enrt_bnft_id = p_enrt_bnft_id
379: and pen.prtt_enrt_rslt_stat_cd is null

Line 440: ben_enrt_bnft enb,

436: select ecr.enrt_rt_id,
437: abc.enrt_ctfn_typ_cd,
438: abc.rqd_flag
439: from ben_enrt_rt ecr,
440: ben_enrt_bnft enb,
441: BEN_ACTY_BASE_RT_CTFN_F abc
442: where ecr.acty_base_rt_id = p_acty_base_rt_id
443: and ecr.business_group_id = p_business_group_id
444: and decode(ecr.enrt_bnft_id, null, ecr.elig_per_elctbl_chc_id,

Line 469: ben_enrt_bnft enb,

465: select ecr.enrt_rt_id,
466: abc.enrt_ctfn_typ_cd,
467: abc.rqd_flag
468: from ben_enrt_rt ecr,
469: ben_enrt_bnft enb,
470: BEN_ACTY_BASE_RT_CTFN_F abc
471: where ecr.acty_base_rt_id = p_acty_base_rt_id
472: and ecr.business_group_id = p_business_group_id
473: and enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 1798: ben_enrt_bnft enb,

1794: pil.ler_id,
1795: pil.person_id
1796: FROM ben_elig_per_elctbl_chc epe,
1797: ben_pil_elctbl_chc_popl pel,
1798: ben_enrt_bnft enb,
1799: ben_per_in_ler pil
1800: WHERE epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id (+)
1801: AND epe.per_in_ler_id = pil.per_in_ler_id
1802: AND epe.per_in_ler_id = pel.per_in_ler_id