APPS.JTF_QUALIFIER_PVT dependencies on USER_SYNONYMS

Line 281: FROM all_tab_columns col, user_synonyms syn

277: IS
278: -- cursor to check that column exists in an Application schema
279: CURSOR c_column_datatype (l_column_name VARCHAR2, l_table_name VARCHAR2, l_apps_schema VARCHAR2) IS
280: SELECT data_type
281: FROM all_tab_columns col, user_synonyms syn
282: WHERE col.column_name = UPPER(l_column_name)
283: AND syn.synonym_name = UPPER(l_table_name)
284: AND col.owner = syn.table_owner
285: AND col.table_name = syn.table_name;

Line 457: FROM all_tab_columns col, user_synonyms syn

453:
454: -- cursor to check that table exists in an Application schema
455: CURSOR c_chk_table_exists (l_table_name VARCHAR2, l_apps_schema VARCHAR2) IS
456: SELECT 'X'
457: FROM all_tab_columns col, user_synonyms syn
458: WHERE syn.synonym_name = UPPER(l_table_name)
459: AND col.owner = syn.table_owner
460: AND col.table_name = syn.table_name;
461:

Line 465: FROM all_tab_columns col, user_synonyms syn

461:
462: -- cursor to check that column exists in an Application schema
463: CURSOR c_chk_col_exists (l_table_name VARCHAR2, l_col_name VARCHAR2, l_apps_schema VARCHAR2) IS
464: SELECT 'X'
465: FROM all_tab_columns col, user_synonyms syn
466: WHERE syn.synonym_name = UPPER(l_table_name)
467: AND col.owner = syn.table_owner
468: AND col.table_name = syn.table_name
469: AND col.column_name = UPPER(l_col_name);