DBA Data[Home] [Help]

APPS.HR_PO_INFO dependencies on ALL_TAB_COLUMNS

Line 127: FROM all_tab_columns dd, user_synonyms syn

123: -- Check if the PO columns are on the HR assignments tables.
124: -- Bug 15914681
125: SELECT count(dd.column_name)
126: INTO l_count
127: FROM all_tab_columns dd, user_synonyms syn
128: WHERE syn.synonym_name = 'PER_ALL_ASSIGNMENTS_F'
129: AND syn.table_owner = dd.owner
130: AND syn.table_name = dd.table_name
131: AND (dd.column_name = 'VENDOR_ID' OR

Line 145: FROM all_tab_columns dd, user_synonyms syn

141: -- Check if VENDOR_ID column exist in the HR assignments table
142: -- -- Bug 15914681
143: SELECT count(dd.column_name)
144: INTO l_count
145: FROM all_tab_columns dd, user_synonyms syn
146: WHERE syn.synonym_name = 'PER_ALL_ASSIGNMENTS_F'
147: AND syn.table_owner = dd.owner
148: AND syn.table_name = dd.table_name
149: AND dd.column_name = 'VENDOR_ID'