DBA Data[Home] [Help]

APPS.IGI_SLS_SECURITY_PKG dependencies on IGI_SLS_SECURE_TABLES_AUDIT

Line 736: UPDATE igi_sls_secure_tables_audit a

732: -- of all actions then this IF condition will have to go.
733: IF rt_c_get_sectab.date_disabled IS NOT NULL
734: OR rt_c_get_sectab.date_removed IS NOT NULL
735: THEN
736: UPDATE igi_sls_secure_tables_audit a
737: SET a.date_security_applied = SYSDATE
738: WHERE a.date_security_applied IS NULL
739: AND ROWID = (SELECT MAX(ROWID) b
740: FROM igi_sls_secure_tables_audit b

Line 740: FROM igi_sls_secure_tables_audit b

736: UPDATE igi_sls_secure_tables_audit a
737: SET a.date_security_applied = SYSDATE
738: WHERE a.date_security_applied IS NULL
739: AND ROWID = (SELECT MAX(ROWID) b
740: FROM igi_sls_secure_tables_audit b
741: WHERE a.table_name = b.table_name
742: AND a.owner = b.owner)
743: AND table_name = rt_c_get_sectab.table_name
744: AND owner = rt_c_get_sectab.owner;