DBA Data[Home] [Help]

APPS.FEM_MULTI_PROC_PKG dependencies on USER_SYNONYMS

Line 654: FROM user_synonyms

650: v_data_table := p_data_table;
651:
652: SELECT table_name,table_owner
653: INTO v_tab_name,v_tab_owner
654: FROM user_synonyms
655: WHERE synonym_name = p_data_table;
656: ELSE
657: v_data_table := p_data_table||'@'||p_source_db_link;
658:

Line 661: ' FROM user_synonyms@'||p_source_db_link||

657: v_data_table := p_data_table||'@'||p_source_db_link;
658:
659: v_sql_cmd :=
660: 'SELECT table_name,table_owner'||
661: ' FROM user_synonyms@'||p_source_db_link||
662: ' WHERE synonym_name = :b_data_table';
663:
664: EXECUTE IMMEDIATE v_sql_cmd
665: INTO v_tab_name,v_tab_owner