APPS.BEN_PROVIDER_POOLS dependencies on BEN_LEE_RSN_F

Line 5065: FROM ben_lee_rsn_f leer,

5061: --
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

Line 5080: FROM ben_lee_rsn_f leer,

5076: AND petc.effective_end_date;
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

Line 6248: FROM ben_lee_rsn_f leer,

6244: --Bug 2386000
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

Line 6263: FROM ben_lee_rsn_f leer,

6259: AND petc.effective_end_date;
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