DBA Data[Home] [Help]

APPS.PQP_EFC_INFO dependencies on USER_SYNONYMS

Line 36: FROM all_tab_columns atc, user_synonyms syn

32: CURSOR csr_test(l_table_name IN VARCHAR2,
33: l_column_name IN VARCHAR2,
34: p_owner IN VARCHAR2) IS
35: SELECT 'Y'
36: FROM all_tab_columns atc, user_synonyms syn
37: WHERE syn.synonym_name = l_table_name
38: AND syn.table_owner = atc.owner
39: AND syn.table_name = atc.table_name
40: AND atc.column_name = l_column_name