APPS.BEN_PROVIDER_POOLS dependencies on BEN_LEE_RSN_F

Line 5242: FROM ben_lee_rsn_f leer,

5238: --
5239: -- Bug 2386000
5240: CURSOR c_lee_rsn_for_plan (c_ler_id number, c_pl_id number ) IS
5241: SELECT leer.lee_rsn_id
5242: FROM ben_lee_rsn_f leer,
5243: ben_popl_enrt_typ_cycl_f petc
5244: WHERE leer.ler_id = c_ler_id
5245: AND leer.business_group_id = p_business_group_id
5246: AND p_effective_date BETWEEN leer.effective_start_date

Line 5257: FROM ben_lee_rsn_f leer,

5253: AND petc.effective_end_date;
5254: --
5255: CURSOR c_lee_rsn_for_program (c_ler_id number, c_pgm_id number )IS
5256: SELECT leer.lee_rsn_id
5257: FROM ben_lee_rsn_f leer,
5258: ben_popl_enrt_typ_cycl_f petc
5259: WHERE leer.ler_id = c_ler_id
5260: AND leer.business_group_id = p_business_group_id
5261: AND p_effective_date BETWEEN leer.effective_start_date

Line 6425: FROM ben_lee_rsn_f leer,

6421: --Bug 2386000
6422: --
6423: CURSOR c_lee_rsn_for_plan (c_ler_id number, c_pl_id number ) IS
6424: SELECT leer.lee_rsn_id
6425: FROM ben_lee_rsn_f leer,
6426: ben_popl_enrt_typ_cycl_f petc
6427: WHERE leer.ler_id = c_ler_id
6428: AND leer.business_group_id = p_business_group_id
6429: AND p_effective_date BETWEEN leer.effective_start_date

Line 6440: FROM ben_lee_rsn_f leer,

6436: AND petc.effective_end_date;
6437: --
6438: CURSOR c_lee_rsn_for_program (c_ler_id number, c_pgm_id number )IS
6439: SELECT leer.lee_rsn_id
6440: FROM ben_lee_rsn_f leer,
6441: ben_popl_enrt_typ_cycl_f petc
6442: WHERE leer.ler_id = c_ler_id
6443: AND leer.business_group_id = p_business_group_id
6444: AND p_effective_date BETWEEN leer.effective_start_date