DBA Data[Home] [Help]

APPS.BEN_EVL_DPNT_ELIG_CRITERIA dependencies on BEN_ELIGY_CRITERIA_DPNT

Line 279: from ben_eligy_criteria_dpnt egc,

275:
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

Line 302: from ben_eligy_criteria_dpnt egc

298: egc.allow_range_validation_flag,
299: egc.allow_range_validation_flag2,
300: egc.name,
301: egc.short_code
302: from ben_eligy_criteria_dpnt egc
303: where eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id ;
304:
305: l_info_egc c_info_egc%rowtype ;
306:

Line 347: l_eror_crit_name ben_eligy_criteria_dpnt.name%type ;

343: l_true_false1 boolean ;
344: l_true_false2 boolean ;
345: l_error_value1 varchar2(4000) ;
346: l_error_value2 varchar2(4000) ;
347: l_eror_crit_name ben_eligy_criteria_dpnt.name%type ;
348: l_overide_found varchar2(1) ;
349: l_crit_found varchar2(1) ;
350: l_fonm_cvg_strt_dt date;
351: