APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_ELIG_MLTRY_STAT_CVG_F
Line 1994: from ben_elig_mltry_stat_cvg_f emc
1990: -- Cursor to get military status criteria
1991: --
1992: cursor c_emc is
1993: select mltry_stat_cd 1994: from ben_elig_mltry_stat_cvg_f emc 1995: where emc.dpnt_cvg_eligy_prfl_id = l_eligy_prfl_id
1996: and emc.business_group_id = l_bg_id
1997: and l_effective_date
1998: between emc.effective_start_date