DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_CRITERIA dependencies on BEN_ELIGY_CRITERIA

Line 652: from ben_eligy_criteria egc,

648: l_effective_date date ;
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

Line 676: from ben_eligy_criteria egc

672: egc.allow_range_validation_flag,
673: egc.allow_range_validation_flag2,
674: egc.name,
675: egc.short_code
676: from ben_eligy_criteria egc
677: where eligy_criteria_id = p_eligy_criteria_id ;
678:
679: l_info_egc c_info_egc%rowtype ;
680:

Line 720: l_eror_crit_name ben_eligy_criteria.name%type ;

716: l_true_false1 boolean ;
717: l_true_false2 boolean ;
718: l_error_value1 varchar2(4000) ;
719: l_error_value2 varchar2(4000) ;
720: l_eror_crit_name ben_eligy_criteria.name%type ;
721: l_overide_found varchar2(1) ;
722: l_crit_found varchar2(1) ;
723:
724: Begin