DBA Data[Home] [Help]

APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_ACTY_BASE_RT_F

Line 36: ben_acty_base_rt_f abr,

32: cursor c_post_tax_contrib(p_eot in date) is
33: select prv.rt_val , prv.tx_typ_cd,prv.acty_typ_cd
34: from ben_prtt_enrt_rslt_f pen,
35: ben_prtt_rt_val prv,
36: ben_acty_base_rt_f abr,
37: ben_pl_f pln,
38: ben_per_in_ler pil
39: where pen.person_id = p_person_id
40: and pen.prtt_enrt_rslt_stat_cd is null

Line 231: from ben_acty_base_rt_f abr

227: and pln.effective_end_date;
228:
229: cursor c_chk_rate_avlbl(p_plan_id in number) is
230: select acty_base_rt_id
231: from ben_acty_base_rt_f abr
232: where abr.pl_id=p_plan_id
233: and p_effective_date between abr.effective_start_date and abr.effective_end_date
234: and abr.business_group_id = p_business_group_id ;
235: