DBA Data[Home] [Help]

APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_ACTY_BASE_RT_F

Line 447: ben_acty_base_rt_f abr,

443: cursor c_post_tax_contrib(p_eot in date) is
444: select prv.rt_val , prv.tx_typ_cd,prv.acty_typ_cd
445: from ben_prtt_enrt_rslt_f pen,
446: ben_prtt_rt_val prv,
447: ben_acty_base_rt_f abr,
448: ben_pl_f pln,
449: ben_per_in_ler pil
450: where pen.person_id = p_person_id
451: and pen.prtt_enrt_rslt_stat_cd is null

Line 717: from ben_acty_base_rt_f abr

713: and pln.effective_end_date;
714:
715: cursor c_chk_rate_avlbl(p_plan_id in number) is
716: select acty_base_rt_id
717: from ben_acty_base_rt_f abr
718: where abr.pl_id=p_plan_id
719: and p_effective_date between abr.effective_start_date and abr.effective_end_date
720: and abr.business_group_id = p_business_group_id ;
721: