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 377: ben_enrt_bnft enb

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

Line 442: ben_enrt_bnft enb,

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

Line 471: ben_enrt_bnft enb,

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

Line 1800: ben_enrt_bnft enb,

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