APPS.GMA_PURGE_ENGINE dependencies on SY_PURG_DEF_ACT

Line 448: , sy_purg_def_act SD

444: , decode(nvl(SD.archive_action,'K'),'D','D','K') arcaction
445: , UU.default_tablespace arctablespace
446: FROM all_tab_columns UC
447: , dba_users UU
448: , sy_purg_def_act SD
449: , sy_purg_def SP
450: WHERE UC.owner = c_schema_name
451: AND UU.USERNAME='GMA'
452: AND SD.purge_type = SP.purge_type

Line 467: , sy_purg_def_act SD

463: UU.default_tablespace
464: )
465: ) arctablespace
466: FROM user_users UU
467: , sy_purg_def_act SD
468: , sy_purg_def SP
469: , all_tab_columns UC
470: WHERE UC.owner='GMA'
471: AND SD.purge_type = SP.purge_type

Line 1479: FROM sy_purg_def_act

1475: -- drop archive tables, reset views
1476:
1477: CURSOR l_viewtables_cur(c_purge_type sy_purg_mst.purge_type%TYPE) IS
1478: SELECT table_name
1479: FROM sy_purg_def_act
1480: WHERE purge_type = c_purge_type;
1481:
1482: BEGIN
1483:

Line 2388: FROM SY_PURG_MST A, Sy_purg_def_act B

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
2388: FROM SY_PURG_MST A, Sy_purg_def_act B
2389: WHERE A.purge_type=B.purge_type AND A.purge_id=ppurge_id
2390: union
2391: SELECT 'T'||LPAD(TO_CHAR(A.purge_id),5,'0')||'_'||'ARCHIVEROWS'
2392: FROM SY_PURG_MST A