DBA Data[Home] [Help]

APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 6832: ben_popl_enrt_typ_cycl_f petc

6828: --
6829: CURSOR c_lee_rsn_for_plan (c_ler_id number, c_pl_id number,c_effective_date date ) IS
6830: SELECT leer.lee_rsn_id
6831: FROM ben_lee_rsn_f leer,
6832: ben_popl_enrt_typ_cycl_f petc
6833: WHERE leer.ler_id = c_ler_id
6834: AND leer.business_group_id = p_business_group_id
6835: AND c_effective_date BETWEEN leer.effective_start_date
6836: AND leer.effective_end_date

Line 6847: ben_popl_enrt_typ_cycl_f petc

6843: --
6844: CURSOR c_lee_rsn_for_program (c_ler_id number, c_pgm_id number,c_effective_date date )IS
6845: SELECT leer.lee_rsn_id
6846: FROM ben_lee_rsn_f leer,
6847: ben_popl_enrt_typ_cycl_f petc
6848: WHERE leer.ler_id = c_ler_id
6849: AND leer.business_group_id = p_business_group_id
6850: AND c_effective_date BETWEEN leer.effective_start_date
6851: AND leer.effective_end_date