DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_LEE_RSN_F

Line 3266: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

3262: leer.enrt_perd_strt_days,
3263: leer.enrt_perd_end_days,
3264: /* bug 2746865*/
3265: leer.enrt_perd_det_ovrlp_bckdt_cd
3266: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
3267: WHERE leer.ler_id = p_ler_id
3268: AND leer.business_group_id = p_business_group_id
3269: AND l_lf_evt_ocrd_dt BETWEEN leer.effective_start_date
3270: AND leer.effective_end_date

Line 3296: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

3292: leer.enrt_perd_strt_days,
3293: leer.enrt_perd_end_days,
3294: /* bug 2746865*/
3295: leer.enrt_perd_det_ovrlp_bckdt_cd
3296: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
3297: WHERE leer.ler_id = p_ler_id
3298: AND leer.business_group_id = p_business_group_id
3299: AND l_lf_evt_ocrd_dt BETWEEN leer.effective_start_date
3300: AND leer.effective_end_date

Line 3592: from ben_lee_rsn_f lee_rsn

3588: ;
3589: --
3590: cursor c_lee_rsn_requery(p_id number,p_ed date) is
3591: select 'Y'
3592: from ben_lee_rsn_f lee_rsn
3593: where lee_rsn_id=p_id and
3594: business_group_id=p_business_group_id and
3595: p_ed between effective_start_date and effective_end_date
3596: ;