DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on ALL_TABLES

Line 209: FROM ALL_TABLES

205: FUNCTION Drop_Temp_Tab_PVT(pTableName VARCHAR2) RETURN BOOLEAN
206: IS
207: CURSOR c_query_table( p_tblname IN VARCHAR2) IS
208: SELECT 1
209: FROM ALL_TABLES
210: WHERE table_name= upper(p_tblname)
211: AND owner = v_msc_schema;
212:
213: lv_table_exist NUMBER;