APPS.BEN_VEP_BUS dependencies on BEN_ELIG_TTL_CVG_VOL_PRTE_F

Line 805: from ben_elig_ttl_cvg_vol_prte_f

801: l_proc varchar2(72) := g_package||'chk_ttlcov_ttlprtt_mutexcl';
802: --
803: cursor c1 is
804: select null
805: from ben_elig_ttl_cvg_vol_prte_f
806: where eligy_prfl_id = p_eligy_prfl_id
807: and exists
808: (select null
809: from ben_elig_ttl_prtt_prte_f

Line 824: from ben_elig_ttl_cvg_vol_prte_f

820: from ben_elig_ttl_prtt_prte_f
821: where eligy_prfl_id = p_eligy_prfl_id
822: and exists
823: (select null
824: from ben_elig_ttl_cvg_vol_prte_f
825: where eligy_prfl_id in
826: (select eligy_prfl_id
827: from ben_vrbl_rt_elig_prfl_f
828: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id

Line 902: from ben_elig_ttl_cvg_vol_prte_f

898: and p_effective_date between effective_start_date and effective_end_date;
899: --
900: cursor c3 is
901: select null
902: from ben_elig_ttl_cvg_vol_prte_f
903: where eligy_prfl_id = p_eligy_prfl_id
904: and business_group_id = p_business_group_id
905: and p_effective_date between effective_start_date and effective_end_date;
906: --