[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;