APPS.BEN_ELEMENT_ENTRY dependencies on BEN_ENRT_RT

Line 2999: FROM ben_enrt_rt ecr,

2995: ----Bug 7196470
2996: cursor c_enrt_rt
2997: is
2998: SELECT ecr.enrt_rt_id
2999: FROM ben_enrt_rt ecr,
3000: ben_prtt_rt_val prv,
3001: ben_acty_base_rt_f abr
3002: WHERE prv.prtt_rt_val_id = ecr.prtt_rt_val_id
3003: AND prv.prtt_rt_val_stat_cd is NULL

Line 3012: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;

3008: AND prv.rt_end_dt > prv.rt_strt_dt
3009: AND ecr.business_group_id = p_business_group_id
3010: AND ecr.prtt_rt_val_id = p_prtt_rt_val_id
3011: AND ecr.acty_base_rt_id = p_acty_base_rt_id;
3012: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
3013:
3014: l_proc varchar2(72) := g_package||'create_enrollment_element';
3015: l_start_date date;
3016: l_end_date date;