DBA Data[Home] [Help]

APPS.BSC_SIMULATION_VIEW_PVT dependencies on ALL_TAB_COLUMNS

Line 332: l_owner all_tab_columns.owner%TYPE;

328: x_num_columns NUMBER;
329: l_new_region_code AK_REGIONS.region_code%TYPE;
330: l_region_code AK_REGIONS.region_code%TYPE;
331: l_count NUMBER;
332: l_owner all_tab_columns.owner%TYPE;
333: l_new_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
334: l_old_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
335: l_parameters FND_FORM_FUNCTIONS.parameters%TYPE;
336: cd BSC_BIS_LOCKS_PUB.t_cursor;

Line 341: FROM all_tab_columns

337:
338:
339: CURSOR c_column IS
340: SELECT column_name
341: FROM all_tab_columns
342: WHERE table_name = p_table_name
343: AND owner = l_owner
344: ORDER BY column_name;
345:

Line 463: FROM all_tab_columns

459: )IS
460:
461: CURSOR c_column IS
462: SELECT column_name
463: FROM all_tab_columns
464: WHERE table_name = p_table_name
465: AND owner = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)
466: ORDER BY column_name;
467: