DBA Data[Home] [Help]

APPS.BSC_MO_HELPER_PKG dependencies on ALL_TAB_COLUMNS

Line 1687: SELECT TABLE_NAME FROM ALL_TAB_COLUMNS

1683: Function table_column_exists(p_table IN VARCHAR2, p_Column IN VARCHAR2) RETURN boolean IS
1684: l_res boolean := false;
1685: l_table VARCHAR2(100);
1686: CURSOR c1 (p3 VARCHAR2) IS
1687: SELECT TABLE_NAME FROM ALL_TAB_COLUMNS
1688: WHERE TABLE_NAME = p_table AND COLUMN_NAME = upper(p_column) AND OWNER = p3;
1689: l_error VARCHAR2(400);
1690: BEGIN
1691: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 5433: SELECT column_name FROM all_tab_columns

5429: l_indicator VARCHAR2(100);
5430: cv CurTyp;
5431: cv1 CurTyp;
5432: CURSOR cColumns (pTableName IN VARCHAR2, pOwner IN VARCHAR2) IS
5433: SELECT column_name FROM all_tab_columns
5434: WHERE table_name = pTableName
5435: AND owner = pOwner
5436: ORDER BY column_id;
5437: