APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_ACTY_BASE_RT_F

Line 494: from ben_acty_base_rt_f abr

490: ,p_effective_date date) is
491: select 'Y'
492: from dual
493: where exists (select null
494: from ben_acty_base_rt_f abr
495: where abr.PARNT_ACTY_BASE_RT_ID = p_acty_base_rt_id
496: and abr.PARNT_CHLD_CD = 'CHLD'
497: and abr.entr_val_at_enrt_flag = 'Y'
498: and abr.ACTY_BASE_RT_STAT_CD = 'A'

Line 502: from ben_acty_base_rt_f abr1,

498: and abr.ACTY_BASE_RT_STAT_CD = 'A'
499: and p_effective_date between
500: abr.effective_start_date and abr.effective_end_date)
501: or exists (select null
502: from ben_acty_base_rt_f abr1,
503: ben_acty_base_rt_f abr2
504: where abr1.acty_base_rt_id = p_acty_base_rt_id
505: and abr1.PARNT_CHLD_CD = 'CHLD'
506: and abr1.PARNT_ACTY_BASE_RT_ID = abr2.acty_base_rt_id

Line 503: ben_acty_base_rt_f abr2

499: and p_effective_date between
500: abr.effective_start_date and abr.effective_end_date)
501: or exists (select null
502: from ben_acty_base_rt_f abr1,
503: ben_acty_base_rt_f abr2
504: where abr1.acty_base_rt_id = p_acty_base_rt_id
505: and abr1.PARNT_CHLD_CD = 'CHLD'
506: and abr1.PARNT_ACTY_BASE_RT_ID = abr2.acty_base_rt_id
507: and abr2.entr_val_at_enrt_flag = 'Y'

Line 817: from ben_acty_base_rt_f

813: ele_entry_val_cd,
814: input_va_calc_rl,
815: effective_start_date,
816: effective_end_date
817: from ben_acty_base_rt_f
818: where acty_base_rt_id = p_acty_base_rt_id
819: and p_eff_dt between effective_start_date
820: and effective_end_date;
821: l_abr c_abr%rowtype;

Line 2419: from ben_acty_base_rt_f abr,

2415: cursor c_abr is
2416: select
2417: abr.*,
2418: py.processing_type
2419: from ben_acty_base_rt_f abr,
2420: pay_element_types_f py
2421: where
2422: abr.acty_base_rt_id = l_acty_base_rt_id
2423: and abr.business_group_id = p_business_group_id

Line 2664: ben_acty_base_rt_f abr

2660: and ecr.elig_per_elctbl_chc_id in
2661: (select
2662: epe.elig_per_elctbl_chc_id
2663: from ben_elig_per_elctbl_chc epe, ben_BNFT_PRVDR_POOL_f bpl,
2664: ben_acty_base_rt_f abr
2665: where epe.BNFT_PRVDR_POOL_ID = p_bnft_prvdr_pool_id
2666: and epe.bnft_prvdr_pool_id = bpl.bnft_prvdr_pool_id
2667: and p_effective_date between bpl.effective_start_date and
2668: bpl.effective_end_date