APPS.ICX_ITEM_DIAG_GRP SQL Statements

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

Line: 198

DELETE FROM po_session_gt WHERE index_char1 in ( ICX_ITEM_DIAG_PVT.g_file_key , ICX_ITEM_DIAG_PVT.g_error_key,ICX_ITEM_DIAG_PVT.g_id_values_key) ;

Line: 325

    SELECT  char1,  char2 ,  char3, char4
    FROM po_session_gt
    WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key;

Line: 380

    SELECT 'TRUE' from dual where exists (select 'Y'
    FROM po_session_gt
    WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key
    and   char4 = 'TRUE' );