[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_statement := 'Select ' || p_column_name ||
' From ' || p_table_name || ' tbl ' ||
' Where person_id = ' || p_person_id ||
' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR')|| ''',''DD-MM-RRRR'') ' ||
' between tbl.effective_start_date and tbl.effective_end_date ' ;
select distinct egc.eligy_criteria_dpnt_id
from ben_eligy_criteria_dpnt egc,
ben_dpnt_eligy_crit_values_f egv
where egv.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
and egv.eligy_criteria_dpnt_id = egc.eligy_criteria_dpnt_id
and egc.business_group_id = p_business_group_id
and egc.criteria_type <> 'SEED'
and l_effective_date between egv.effective_Start_date
and egv.effective_end_date ;
select egc.criteria_type ,
egc.crit_col1_val_type_cd,
egc.crit_col1_datatype,
egc.access_table_name1,
egc.access_column_name1,
egc.crit_col2_datatype,
egc.access_table_name2,
egc.access_column_name2,
egc.allow_range_validation_flag,
egc.allow_range_validation_flag2,
egc.name,
egc.short_code
from ben_eligy_criteria_dpnt egc
where eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id ;
select egv.number_value1 ,
egv.number_value2 ,
egv.char_value1 ,
egv.char_value2 ,
egv.date_value1 ,
egv.date_value2 ,
egv.number_value3 ,
egv.number_value4 ,
egv.char_value3 ,
egv.char_value4 ,
egv.date_value3 ,
egv.date_value4 ,
egv.EXCLD_FLAG
from ben_dpnt_eligy_crit_values_f egv
where egv.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
and egv.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id
and egv.business_group_id = p_business_group_id
and p_effective_date between egv.effective_Start_date
and egv.effective_end_date
-- order by ordr_num
;