DBA Data[Home] [Help]

APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_LEE_RSN_F

Line 6520: FROM ben_lee_rsn_f leer,

6516: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
6517: --
6518: CURSOR c_lee_rsn_for_plan (c_ler_id number, c_pl_id number,c_effective_date date ) IS
6519: SELECT leer.lee_rsn_id
6520: FROM ben_lee_rsn_f leer,
6521: ben_popl_enrt_typ_cycl_f petc
6522: WHERE leer.ler_id = c_ler_id
6523: AND leer.business_group_id = p_business_group_id
6524: AND c_effective_date BETWEEN leer.effective_start_date

Line 6535: FROM ben_lee_rsn_f leer,

6531: AND petc.effective_end_date;
6532: --
6533: CURSOR c_lee_rsn_for_program (c_ler_id number, c_pgm_id number,c_effective_date date )IS
6534: SELECT leer.lee_rsn_id
6535: FROM ben_lee_rsn_f leer,
6536: ben_popl_enrt_typ_cycl_f petc
6537: WHERE leer.ler_id = c_ler_id
6538: AND leer.business_group_id = p_business_group_id
6539: AND c_effective_date BETWEEN leer.effective_start_date