DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_CRITERIA dependencies on BEN_ELIGY_CRIT_VALUES_F

Line 653: ben_eligy_crit_values_f egv

649:
650: cursor c_dst_egc is
651: select distinct egc.eligy_criteria_id
652: from ben_eligy_criteria egc,
653: ben_eligy_crit_values_f egv
654: where egv.eligy_prfl_id = p_eligy_prfl_id
655: and egv.eligy_criteria_id = egc.eligy_criteria_id
656: and egc.business_group_id = p_business_group_id
657: and egc.criteria_type <> 'SEED'

Line 696: from ben_eligy_crit_values_f egv

692: egv.char_value4 ,
693: egv.date_value3 ,
694: egv.date_value4 ,
695: egv.EXCLD_FLAG
696: from ben_eligy_crit_values_f egv
697: where egv.eligy_prfl_id = p_eligy_prfl_id
698: and egv.eligy_criteria_id = p_eligy_criteria_id
699: and egv.business_group_id = p_business_group_id
700: and p_effective_date between egv.effective_Start_date