APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_ACTY_BASE_RT_F

Line 496: from ben_acty_base_rt_f abr,

492: --
493: -- FONM
494: cursor c_abr(cv_effective_date date) is
495: select abr2.acty_base_rt_id
496: from ben_acty_base_rt_f abr,
497: ben_paird_rt_f prd,
498: ben_acty_base_rt_f abr2
499: where abr.acty_base_rt_id = p_acty_base_rt_id
500: and abr.acty_base_rt_id = prd.chld_acty_base_rt_id

Line 498: ben_acty_base_rt_f abr2

494: cursor c_abr(cv_effective_date date) is
495: select abr2.acty_base_rt_id
496: from ben_acty_base_rt_f abr,
497: ben_paird_rt_f prd,
498: ben_acty_base_rt_f abr2
499: where abr.acty_base_rt_id = p_acty_base_rt_id
500: and abr.acty_base_rt_id = prd.chld_acty_base_rt_id
501: and abr2.acty_base_rt_id = prd.parnt_acty_base_rt_id
502: and abr2.parnt_chld_cd = 'PARNT'

Line 516: from ben_acty_base_rt_f abr

512: and rownum = 1;
513: --
514: cursor c_prem_abr(cv_effective_date date) is
515: select abr.actl_prem_id
516: from ben_acty_base_rt_f abr
517: where abr.acty_base_rt_id = p_acty_base_rt_id
518: and cv_effective_date between abr.effective_start_date and
519: abr.effective_end_date;
520: --