APPS.BEN_ABR_BUS dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 599: cursor c_cvg is select 'x' from ben_cvg_amt_calc_mthd_f

595: p_effective_date in date ) return varchar2 is
596:
597: l_proc varchar2(72) := g_package||'chk_pl_with_cvg';
598:
599: cursor c_cvg is select 'x' from ben_cvg_amt_calc_mthd_f
600: where pl_id = p_pl_id and
601: entr_val_at_enrt_flag = 'Y' and
602: p_effective_Date between effective_start_date and effective_end_Date ;
603:

Line 629: cursor c_cvg is select 'x' from ben_cvg_amt_calc_mthd_f

625: p_effective_date in date ) return varchar2 is
626:
627: l_proc varchar2(72) := g_package||'chk_oipl_with_cvg';
628:
629: cursor c_cvg is select 'x' from ben_cvg_amt_calc_mthd_f
630: where oipl_id = p_oipl_id and
631: entr_val_at_enrt_flag = 'Y' and
632: p_effective_Date between effective_start_date and effective_end_Date ;
633: