DBA Data[Home] [Help]

APPS.CCT_SRSEC_CHECK_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

         SELECT agent_id, resp_id, app_id  FROM cct_agent_rt_stats
         WHERE agent_id IN (p_agentIDs) AND attribute1 = 'T';
Line: 65

        p_table.DELETE(p_table.LAST);
Line: 165

    SELECT Count(*) INTO l_ver
    FROM cct_security_functions
    WHERE application_id=170 AND version=1.0 ;