APPS.BEN_ELEMENT_ENTRY dependencies on BEN_ENRT_RT

Line 3133: FROM ben_enrt_rt ecr,

3129: ----Bug 7196470
3130: cursor c_enrt_rt
3131: is
3132: SELECT ecr.enrt_rt_id
3133: FROM ben_enrt_rt ecr,
3134: ben_prtt_rt_val prv,
3135: ben_acty_base_rt_f abr
3136: WHERE prv.prtt_rt_val_id = ecr.prtt_rt_val_id
3137: AND prv.prtt_rt_val_stat_cd is NULL

Line 3146: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;

3142: AND prv.rt_end_dt > prv.rt_strt_dt
3143: AND ecr.business_group_id = p_business_group_id
3144: AND ecr.prtt_rt_val_id = p_prtt_rt_val_id
3145: AND ecr.acty_base_rt_id = p_acty_base_rt_id;
3146: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
3147:
3148: ------------------Bug 8872583
3149: cursor c_chk_pay_periods(p_payroll_id number,p_date date)
3150: is