APPS.BEN_VEP_BUS dependencies on BEN_ELIG_TTL_CVG_VOL_PRTE_F

Line 919: from ben_elig_ttl_cvg_vol_prte_f

915: l_proc varchar2(72) := g_package||'chk_ttlcov_ttlprtt_mutexcl';
916: --
917: cursor c1 is
918: select null
919: from ben_elig_ttl_cvg_vol_prte_f
920: where eligy_prfl_id = p_eligy_prfl_id
921: and exists
922: (select null
923: from ben_elig_ttl_prtt_prte_f

Line 938: from ben_elig_ttl_cvg_vol_prte_f

934: from ben_elig_ttl_prtt_prte_f
935: where eligy_prfl_id = p_eligy_prfl_id
936: and exists
937: (select null
938: from ben_elig_ttl_cvg_vol_prte_f
939: where eligy_prfl_id in
940: (select eligy_prfl_id
941: from ben_vrbl_rt_elig_prfl_f
942: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id

Line 1016: from ben_elig_ttl_cvg_vol_prte_f

1012: and p_effective_date between effective_start_date and effective_end_date;
1013: --
1014: cursor c3 is
1015: select null
1016: from ben_elig_ttl_cvg_vol_prte_f
1017: where eligy_prfl_id = p_eligy_prfl_id
1018: and business_group_id = p_business_group_id
1019: and p_effective_date between effective_start_date and effective_end_date;
1020: --