APPS.HZ_MERGE_DICTIONARY_PKG dependencies on ALL_TAB_COLUMNS

Line 97: FROM sys.ALL_TAB_COLUMNS

93: l_bool BOOLEAN;
94:
95: CURSOR c_table_col IS
96: SELECT 'Exists'
97: FROM sys.ALL_TAB_COLUMNS
98: WHERE TABLE_NAME = p_entity_name
99: AND COLUMN_NAME = p_primary_key
100: --and owner = l_owner1;
101: and rownum = 1;

Line 147: FROM sys.ALL_TAB_COLUMNS

143: l_temp VARCHAR2(255);
144: l_bool BOOLEAN;
145: CURSOR c_table_col IS
146: SELECT 'Exists'
147: FROM sys.ALL_TAB_COLUMNS
148: WHERE TABLE_NAME = p_entity_name
149: AND COLUMN_NAME = p_foreign_key
150: --and owner = l_owner1;
151: and rownum = 1;