[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select rule_id bulk collect into l_rule_id_tbl from iec_g_rules
where owner_id = p_owner_id and owner_type_code = p_owner_type;
select criteria_id, combination_code bulk collect into l_criteria_id_tbl, l_comb_code_tbl
from iec_g_field_criteria where rule_id = l_rule_id_tbl(j);
select A.field_name,UPPER(LTRIM(RTRIM(A.field_value,' '),' ')),
UPPER(LTRIM(RTRIM(A.operator_code,' '),' ')),
UPPER(LTRIM(RTRIM(B.sql_operator,' '),' ')),
B.is_unary_flag bulk collect into l_field_name_tbl,l_field_value_tbl,
l_operator_code_tbl,l_sql_operator_tbl,
l_unary_flag_tbl from iec_g_fields A, iec_o_alg_op_defs_b B
where A.criteria_id = l_criteria_id_tbl(k) and A.operator_code = B.operator_code;
select default_subset_flag into l_default_subset_flag from iec_g_list_subsets
where list_subset_id = p_owner_id ;
select rule_id bulk collect into l_rule_id_tbl from iec_g_rules
where owner_id = p_owner_id and owner_type_code = p_owner_type;
select list_subset_id bulk collect into l_subset_id_tbl from iec_g_list_subsets where list_header_id in
(select list_header_id from iec_g_list_subsets where list_subset_id = p_owner_id )
and ( default_subset_flag <>'Y' or default_subset_flag is null);
select b.tag into l_viewname from ams_list_headers_all a, iec_lookups b where
a.list_header_id = listHeaderId and b.lookup_type='IEC_SOURCE_VIEW_MAP' and a.list_source_type = b.lookup_code;