APPS.BSC_DESIGNER_PVT dependencies on ALL_TAB_COLUMNS

Line 414: FROM all_tab_columns

410: )IS
411:
412: CURSOR c_column IS
413: SELECT column_name
414: FROM all_tab_columns
415: WHERE table_name = p_table_name
416: AND owner = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)
417: ORDER BY column_name;
418:

Line 1751: SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS

1747:
1748: PROCEDURE Duplicate_Record_by_Indicator(x_table_name IN VARCHAR2, x_Src_kpi IN NUMBER, x_Trg_kpi IN NUMBER ) IS
1749:
1750: CURSOR c_column IS
1751: SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS
1752: WHERE TABLE_NAME = x_table_name
1753: AND OWNER = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)
1754: ORDER BY COLUMN_NAME;
1755:

Line 1898: FROM all_tab_columns

1894: )
1895: IS
1896: CURSOR c_column IS
1897: SELECT column_name
1898: FROM all_tab_columns
1899: WHERE table_name = p_table_name
1900: AND owner = DECODE(USER, BSC_APPS.get_user_schema('APPS'), BSC_APPS.get_user_schema, USER)
1901: AND UPPER(column_name) <> 'KPI_MEASURE_ID'
1902: AND UPPER(column_name) <> 'INDICATOR'

Line 2949: all_tab_columns

2945: CURSOR c_column IS
2946: SELECT
2947: column_name
2948: FROM
2949: all_tab_columns
2950: WHERE
2951: table_name = p_table_name
2952: AND
2953: owner = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)

Line 3114: l_owner all_tab_columns.owner%TYPE;

3110: l_trg_languages BSC_UPDATE_UTIL.t_array_of_varchar2;
3111: l_num_trg_languages NUMBER := 0;
3112:
3113: l_src_base_language VARCHAR2(4);
3114: l_owner all_tab_columns.owner%TYPE;
3115:
3116: CURSOR c_columns_apps IS
3117: SELECT
3118: column_name

Line 3120: all_tab_columns

3116: CURSOR c_columns_apps IS
3117: SELECT
3118: column_name
3119: FROM
3120: all_tab_columns
3121: WHERE
3122: table_name = p_table_name
3123: AND
3124: owner = l_owner