DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_ELIG_MRTL_STAT_CVG_F

Line 1909: from ben_elig_mrtl_stat_cvg_f ems

1905: -- Cursor to get marital status criteria
1906: --
1907: cursor c_ems is
1908: select mrtl_stat_cd
1909: from ben_elig_mrtl_stat_cvg_f ems
1910: where ems.dpnt_cvg_eligy_prfl_id = l_eligy_prfl_id
1911: and ems.business_group_id = l_bg_id
1912: and l_effective_date
1913: between ems.effective_start_date