The following lines contain the word 'select', 'insert', 'update' or 'delete':
Line: 11
select lookup_code_pk
from edw_lookup_code_fkv
where lookup_type = p_lookup_type
and lookup_code = p_lookup_code
and table_code = p_lookup_table;
Line: 47
select lookup_code_pk
from edw_lookup_code_fkv
where lookup_type = p_lookup_type
and lookup_code = to_char (p_lookup_code)
and table_code = p_lookup_table;