DBA Data[Home] [Help]

APPS.BSC_SYNC_MVLOGS dependencies on USER_SYNONYMS

Line 25: cursor c1(p_table varchar2) is select table_owner from user_synonyms where synonym_name=p_table;

21:
22: function get_table_owner(p_table varchar2) return varchar2 is
23: l_owner varchar2(400);
24: l_stmt varchar2(4000);
25: cursor c1(p_table varchar2) is select table_owner from user_synonyms where synonym_name=p_table;
26: -----------------------------------
27: Begin
28: if instr(p_table,'.')<>0 then
29: l_owner:=substr(p_table,1,instr(p_table,'.')-1);