APPS.BEN_PROVIDER_POOLS dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 5066: ben_popl_enrt_typ_cycl_f petc

5062: -- Bug 2386000
5063: CURSOR c_lee_rsn_for_plan (c_ler_id number, c_pl_id number ) IS
5064: SELECT leer.lee_rsn_id
5065: FROM ben_lee_rsn_f leer,
5066: ben_popl_enrt_typ_cycl_f petc
5067: WHERE leer.ler_id = c_ler_id
5068: AND leer.business_group_id = p_business_group_id
5069: AND p_effective_date BETWEEN leer.effective_start_date
5070: AND leer.effective_end_date

Line 5081: ben_popl_enrt_typ_cycl_f petc

5077: --
5078: CURSOR c_lee_rsn_for_program (c_ler_id number, c_pgm_id number )IS
5079: SELECT leer.lee_rsn_id
5080: FROM ben_lee_rsn_f leer,
5081: ben_popl_enrt_typ_cycl_f petc
5082: WHERE leer.ler_id = c_ler_id
5083: AND leer.business_group_id = p_business_group_id
5084: AND p_effective_date BETWEEN leer.effective_start_date
5085: AND leer.effective_end_date

Line 6249: ben_popl_enrt_typ_cycl_f petc

6245: --
6246: CURSOR c_lee_rsn_for_plan (c_ler_id number, c_pl_id number ) IS
6247: SELECT leer.lee_rsn_id
6248: FROM ben_lee_rsn_f leer,
6249: ben_popl_enrt_typ_cycl_f petc
6250: WHERE leer.ler_id = c_ler_id
6251: AND leer.business_group_id = p_business_group_id
6252: AND p_effective_date BETWEEN leer.effective_start_date
6253: AND leer.effective_end_date

Line 6264: ben_popl_enrt_typ_cycl_f petc

6260: --
6261: CURSOR c_lee_rsn_for_program (c_ler_id number, c_pgm_id number )IS
6262: SELECT leer.lee_rsn_id
6263: FROM ben_lee_rsn_f leer,
6264: ben_popl_enrt_typ_cycl_f petc
6265: WHERE leer.ler_id = c_ler_id
6266: AND leer.business_group_id = p_business_group_id
6267: AND p_effective_date BETWEEN leer.effective_start_date
6268: AND leer.effective_end_date