DBA Data[Home] [Help]

APPS.EDW_LOOKUP_PKG SQL Statements

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;