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_RATE_CHG dependencies on BEN_ACTY_BASE_RT_F

Line 468: from ben_acty_base_rt_f abr

464: ,p_effective_date date) is
465: select 'Y'
466: from dual
467: where exists (select null
468: from ben_acty_base_rt_f abr
469: where abr.PARNT_ACTY_BASE_RT_ID = p_acty_base_rt_id
470: and abr.PARNT_CHLD_CD = 'CHLD'
471: and abr.entr_val_at_enrt_flag = 'Y'
472: and abr.ACTY_BASE_RT_STAT_CD = 'A'

Line 476: from ben_acty_base_rt_f abr1,

472: and abr.ACTY_BASE_RT_STAT_CD = 'A'
473: and p_effective_date between
474: abr.effective_start_date and abr.effective_end_date)
475: or exists (select null
476: from ben_acty_base_rt_f abr1,
477: ben_acty_base_rt_f abr2
478: where abr1.acty_base_rt_id = p_acty_base_rt_id
479: and abr1.PARNT_CHLD_CD = 'CHLD'
480: and abr1.PARNT_ACTY_BASE_RT_ID = abr2.acty_base_rt_id

Line 477: ben_acty_base_rt_f abr2

473: and p_effective_date between
474: abr.effective_start_date and abr.effective_end_date)
475: or exists (select null
476: from ben_acty_base_rt_f abr1,
477: ben_acty_base_rt_f abr2
478: where abr1.acty_base_rt_id = p_acty_base_rt_id
479: and abr1.PARNT_CHLD_CD = 'CHLD'
480: and abr1.PARNT_ACTY_BASE_RT_ID = abr2.acty_base_rt_id
481: and abr2.entr_val_at_enrt_flag = 'Y'

Line 769: from ben_acty_base_rt_f

765: ele_entry_val_cd,
766: input_va_calc_rl,
767: effective_start_date,
768: effective_end_date
769: from ben_acty_base_rt_f
770: where acty_base_rt_id = p_acty_base_rt_id
771: and p_eff_dt between effective_start_date
772: and effective_end_date;
773: l_abr c_abr%rowtype;

Line 2236: from ben_acty_base_rt_f abr,

2232: cursor c_abr is
2233: select
2234: abr.*,
2235: py.processing_type
2236: from ben_acty_base_rt_f abr,
2237: pay_element_types_f py
2238: where
2239: abr.acty_base_rt_id = l_acty_base_rt_id
2240: and abr.business_group_id = p_business_group_id

Line 2481: ben_acty_base_rt_f abr

2477: and ecr.elig_per_elctbl_chc_id in
2478: (select
2479: epe.elig_per_elctbl_chc_id
2480: from ben_elig_per_elctbl_chc epe, ben_BNFT_PRVDR_POOL_f bpl,
2481: ben_acty_base_rt_f abr
2482: where epe.BNFT_PRVDR_POOL_ID = p_bnft_prvdr_pool_id
2483: and epe.bnft_prvdr_pool_id = bpl.bnft_prvdr_pool_id
2484: and p_effective_date between bpl.effective_start_date and
2485: bpl.effective_end_date