DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_DPNT_CVRD_ANTHR_PL_CVG_F

Line 2482: from ben_dpnt_cvrd_anthr_pl_cvg_f dpc

2478: -- Cursor to get pl_id criteria
2479: --
2480: cursor c_get_cvrd_anthr_pl is
2481: select dpc.pl_id,dpc.cvg_det_dt_cd, dpc.excld_flag
2482: from ben_dpnt_cvrd_anthr_pl_cvg_f dpc
2483: where dpc.dpnt_cvg_eligy_prfl_id = p_eligy_prfl_id
2484: and dpc.business_group_id = p_business_group_id
2485: and l_effective_date
2486: between dpc.effective_start_date