DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 8494: FROM ben_ler_chg_dpnt_cvg_f ldc

8490: CURSOR c_ler_chg_dep IS
8491: SELECT '1',
8492: ldc.ler_chg_dpnt_cvg_cd,
8493: ldc.ler_chg_dpnt_cvg_rl
8494: FROM ben_ler_chg_dpnt_cvg_f ldc
8495: WHERE ldc.ler_id = p_ler_id
8496: AND ldc.business_group_id = p_business_group_id
8497: AND ldc.pl_id = p_pl_id
8498: AND l_lf_evt_ocrd_dt BETWEEN ldc.effective_start_date

Line 8505: FROM ben_ler_chg_dpnt_cvg_f ldc

8501: UNION ALL
8502: SELECT '2',
8503: ldc.ler_chg_dpnt_cvg_cd,
8504: ldc.ler_chg_dpnt_cvg_rl
8505: FROM ben_ler_chg_dpnt_cvg_f ldc
8506: WHERE ldc.ler_id = p_ler_id
8507: AND ldc.business_group_id = p_business_group_id
8508: AND ldc.ptip_id = p_ptip_id
8509: AND l_lf_evt_ocrd_dt BETWEEN ldc.effective_start_date

Line 8516: FROM ben_ler_chg_dpnt_cvg_f ldc

8512: UNION ALL
8513: SELECT '3',
8514: ldc.ler_chg_dpnt_cvg_cd,
8515: ldc.ler_chg_dpnt_cvg_rl
8516: FROM ben_ler_chg_dpnt_cvg_f ldc
8517: WHERE ldc.ler_id = p_ler_id
8518: AND ldc.business_group_id = p_business_group_id
8519: AND ldc.pgm_id = p_pgm_id
8520: AND l_lf_evt_ocrd_dt BETWEEN ldc.effective_start_date