APPS.GMA_PURGE_ENGINE dependencies on ALL_TABLES

Line 507: l_tablename_row.arctable || ' does not exist in ALL_TABLES.');

503: -- make sure the table exists
504: IF (GMA_PURGE_VALIDATE.is_table(p_purge_id,l_tablename_row.arctable) <> TRUE) THEN
505: GMA_PURGE_UTILITIES.printlong(p_purge_id,
506: 'Problem with ' || p_arctablename || ' - ' ||
507: l_tablename_row.arctable || ' does not exist in ALL_TABLES.');
508: RETURN FALSE;
509: END IF;
510:
511: -- create archive table

Line 2383: FROM all_tables

2379: --archive_action equal to 'K'
2380: Cursor Cur_dropTbl(ppurge_id sy_purg_mst.purge_id%TYPE,
2381: c_schema_name VARCHAR2) is
2382: SELECT owner,table_name
2383: FROM all_tables
2384: WHERE owner = c_schema_name
2385: AND
2386: table_name IN(
2387: SELECT 'T' ||LPAD(TO_CHAR(A.purge_id),5,'0')||'_'||B.table_name