DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_ELIG_TTL_PRTT_PRTE_F

Line 923: from ben_elig_ttl_prtt_prte_f

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
924: where eligy_prfl_id in
925: (select eligy_prfl_id
926: from ben_vrbl_rt_elig_prfl_f
927: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id

Line 934: from ben_elig_ttl_prtt_prte_f

930: or eligy_prfl_id = p_eligy_prfl_id);
931: --
932: cursor c2 is
933: select null
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

Line 1009: from ben_elig_ttl_prtt_prte_f

1005: and p_effective_date between effective_start_date and effective_end_date;
1006: --
1007: cursor c2 is
1008: select null
1009: from ben_elig_ttl_prtt_prte_f
1010: where eligy_prfl_id = p_eligy_prfl_id
1011: and business_group_id = p_business_group_id
1012: and p_effective_date between effective_start_date and effective_end_date;
1013: --