eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EVL_DPNT_ELIG_CRITERIA dependencies on BEN_DPNT_ELIGY_CRIT_VALUES_F

Line 280: ben_dpnt_eligy_crit_values_f egv

276:
277: cursor c_dst_egc is
278: select distinct egc.eligy_criteria_dpnt_id
279: from ben_eligy_criteria_dpnt egc,
280: ben_dpnt_eligy_crit_values_f egv
281: where egv.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
282: and egv.eligy_criteria_dpnt_id = egc.eligy_criteria_dpnt_id
283: and egc.business_group_id = p_business_group_id
284: and egc.criteria_type <> 'SEED'

Line 323: from ben_dpnt_eligy_crit_values_f egv

319: egv.char_value4 ,
320: egv.date_value3 ,
321: egv.date_value4 ,
322: egv.EXCLD_FLAG
323: from ben_dpnt_eligy_crit_values_f egv
324: where egv.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
325: and egv.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id
326: and egv.business_group_id = p_business_group_id
327: and p_effective_date between egv.effective_Start_date