APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_ACTY_BASE_RT_F

Line 462: from ben_acty_base_rt_f abr,

458: --
459: -- FONM
460: cursor c_abr(cv_effective_date date) is
461: select abr2.acty_base_rt_id
462: from ben_acty_base_rt_f abr,
463: ben_paird_rt_f prd,
464: ben_acty_base_rt_f abr2
465: where abr.acty_base_rt_id = p_acty_base_rt_id
466: and abr.acty_base_rt_id = prd.chld_acty_base_rt_id

Line 464: ben_acty_base_rt_f abr2

460: cursor c_abr(cv_effective_date date) is
461: select abr2.acty_base_rt_id
462: from ben_acty_base_rt_f abr,
463: ben_paird_rt_f prd,
464: ben_acty_base_rt_f abr2
465: where abr.acty_base_rt_id = p_acty_base_rt_id
466: and abr.acty_base_rt_id = prd.chld_acty_base_rt_id
467: and abr2.acty_base_rt_id = prd.parnt_acty_base_rt_id
468: and abr2.parnt_chld_cd = 'PARNT'

Line 482: from ben_acty_base_rt_f abr

478: and rownum = 1;
479: --
480: cursor c_prem_abr(cv_effective_date date) is
481: select abr.actl_prem_id
482: from ben_acty_base_rt_f abr
483: where abr.acty_base_rt_id = p_acty_base_rt_id
484: and cv_effective_date between abr.effective_start_date and
485: abr.effective_end_date;
486: --