APPS.GMA_PURGE_DDL dependencies on SY_PURG_DEF_ACT

Line 229: FROM sy_purg_def_act

225: -- create views of archive tables
226:
227: /* CURSOR l_viewtables_cur(cp_purge_type sy_purg_def.purge_type%TYPE) IS
228: SELECT table_name
229: FROM sy_purg_def_act
230: WHERE purge_type = cp_purge_type;
231: l_tablename user_tables.table_name%TYPE;
232:
233: CURSOR l_arctables_cur(cp_tablename user_tables.table_name%TYPE) IS

Line 421: FROM sy_purg_def_act

417: -- disable or enable all constraints for named table
418:
419: CURSOR l_tablename_cur(P_purge_id sy_purg_mst.purge_id%TYPE) IS
420: SELECT table_name,archive_action
421: FROM sy_purg_def_act
422: WHERE
423: Purge_type=(select PURGE_TYPE from sy_purg_mst where Purge_id=P_purge_id);
424:
425: TYPE archive_table_rec_type IS RECORD(