APPS.BEN_DM_UTILITY dependencies on ALL_TAB_COLUMNS

Line 1198: FROM sys.all_tab_columns cols1

1194:
1195: -- Get columns for seeding
1196: CURSOR csr_get_columns IS
1197: SELECT column_name, data_type
1198: FROM sys.all_tab_columns cols1
1199: WHERE data_type in ('NUMBER','VARCHAR2','DATE')
1200: AND table_name = p_table_name
1201: AND column_name not in ('REQUEST_ID','PROGRAM_APPLICATION_ID','PROGRAM_ID','PROGRAM_UPDATE_DATE')
1202: AND data_length < 2001

Line 1214: FROM sys.all_tab_columns

1210: CURSOR csr_get_er_columns (p_data_type VARCHAR2,
1211: p_table_id NUMBER,
1212: p_column_name VARCHAR2) IS
1213: SELECT column_name
1214: FROM sys.all_tab_columns
1215: WHERE data_type = p_data_type
1216: AND table_name = 'BEN_DM_ENTITY_RESULTS'
1217: AND column_name not in ('ENTITY_RESULT_ID','MIGRATION_ID','TABLE_NAME','GROUP_ORDER')
1218: AND column_name not in (SELECT entity_result_column_name