DBA Data[Home] [Help]

APPS.BSC_BIS_MEASURE_PUB dependencies on USER_TAB_COLUMNS

Line 4330: l_data_type USER_TAB_COLUMNS.DATA_TYPE%TYPE;

4326: ,p_column_name IN VARCHAR2
4327: ) RETURN VARCHAR2
4328: IS
4329: l_ret_val VARCHAR2(1) := 'F';
4330: l_data_type USER_TAB_COLUMNS.DATA_TYPE%TYPE;
4331: BEGIN
4332: SELECT data_type INTO l_data_type
4333: FROM user_tab_columns
4334: WHERE table_name = p_table_name

Line 4333: FROM user_tab_columns

4329: l_ret_val VARCHAR2(1) := 'F';
4330: l_data_type USER_TAB_COLUMNS.DATA_TYPE%TYPE;
4331: BEGIN
4332: SELECT data_type INTO l_data_type
4333: FROM user_tab_columns
4334: WHERE table_name = p_table_name
4335: AND column_name = p_column_name;
4336:
4337: IF (l_data_type = 'NUMBER') THEN