APPS.HR_ADE_ADI_DATA_SETUP dependencies on ALL_TAB_COLUMNS

Line 28: FROM all_tab_columns tc, user_synonyms syn

24: --
25: -- Bug 15914681
26: CURSOR csr_test_for_flag (l_oracle_schema IN varchar) IS
27: SELECT 'Y'
28: FROM all_tab_columns tc, user_synonyms syn
29: WHERE syn.synonym_name = 'BNE_INTEGRATORS_B'
30: AND syn.table_name = tc.table_name
31: AND syn.table_owner = tc.owner
32: AND tc.column_name = 'NEW_SESSION_FLAG'

Line 351: ' FROM ALL_TAB_COLUMNS atc, user_synonyms syn' ||

347: END;
348: -- Bug 15914681
349: OPEN csr_int for
350: ' SELECT column_name , data_type ' ||
351: ' FROM ALL_TAB_COLUMNS atc, user_synonyms syn' ||
352: ' WHERE syn.synonym_name = ''' || P_VIEW_NAME ||
353: ''' AND owner = ''' || VV_ORACLE_USER || '''' ||
354: ' AND syn.table_owner = atc.owner' ||
355: ' AND syn.table_name = atc.table_name';