APPS.XNP_SV_NETWORK$SMS_ORDER SQL Statements

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

Line: 125

      I_QUERY := 'SELECT count(*)' ||
                 substr(ZONE_SQL, I_FROM_POS);

Line: 171

      ZONE_SQL := 'SELECT SOG.SV_ORDER_MAPPING_ID,
                         SOG.ORDER_ID,
                         SOG.WORKITEM_INSTANCE_ID
                  FROM   XNP_SV_ORDER_MAPPINGS SOG';