DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_ELIG_TTL_PRTT_PRTE_F

Line 809: from ben_elig_ttl_prtt_prte_f

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
810: where eligy_prfl_id in
811: (select eligy_prfl_id
812: from ben_vrbl_rt_elig_prfl_f
813: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id

Line 820: from ben_elig_ttl_prtt_prte_f

816: or eligy_prfl_id = p_eligy_prfl_id);
817: --
818: cursor c2 is
819: select null
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

Line 895: from ben_elig_ttl_prtt_prte_f

891: and p_effective_date between effective_start_date and effective_end_date;
892: --
893: cursor c2 is
894: select null
895: from ben_elig_ttl_prtt_prte_f
896: where eligy_prfl_id = p_eligy_prfl_id
897: and business_group_id = p_business_group_id
898: and p_effective_date between effective_start_date and effective_end_date;
899: --