DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_DSGNTR_ENRLD_CVG_F

Line 2588: from ben_dsgntr_enrld_cvg_f dec

2584: -- Cursor to get criteria
2585: --
2586: cursor c_get_dsgntr_enrld_cvg is
2587: select dec.dsgntr_crntly_enrld_flag
2588: from ben_dsgntr_enrld_cvg_f dec
2589: where dec.dpnt_cvg_eligy_prfl_id = p_eligy_prfl_id
2590: and dec.business_group_id = p_business_group_id
2591: and l_effective_date
2592: between dec.effective_start_date