DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_SCHEDD_HRS_PRTE_F

Line 5104: from ben_elig_schedd_hrs_prte_f esh

5100: where p_effective_date
5101: between elp.effective_start_date
5102: and elp.effective_end_date
5103: and exists(select null
5104: from ben_elig_schedd_hrs_prte_f esh
5105: where p_effective_date
5106: between esh.effective_start_date
5107: and esh.effective_end_date
5108: and esh.eligy_prfl_id = elp.eligy_prfl_id)

Line 5126: from ben_elig_schedd_hrs_prte_f esh

5122: esh.freq_cd,
5123: esh.excld_flag,
5124: esh.criteria_score,
5125: esh.criteria_weight
5126: from ben_elig_schedd_hrs_prte_f esh
5127: where p_effective_date
5128: between esh.effective_start_date
5129: and esh.effective_end_date
5130: order by esh.eligy_prfl_id,