APPS.XNP_CALLBACK_EVENTS$XNP_CALLBA SQL Statements

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

Line: 177

      select L_MTE.MSG_CODE
      into   CURR_VAL.MSG_CODE
      from   XNP_MSG_TYPES_B L_MTE
      where  rownum = 1
      and   ( L_MTE.MSG_CODE = P_MSG_CODE );

Line: 312

               select L_MTE.MSG_CODE MSG_CODE
               from   XNP_MSG_TYPES_B L_MTE
               where  L_MTE.MSG_CODE like upper(srch)
               order by L_MTE.MSG_CODE;

Line: 523

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

Line: 631

      ZONE_SQL := 'SELECT CET.ORDER_ID,
                         CET.STATUS,
                         CET.MSG_CODE,
                         CET.CALLBACK_PROC_NAME,
                         CET.CALLBACK_TYPE,
                         CET.PROCESS_REFERENCE,
                         CET.REFERENCE_ID,
                         CET.CLOSE_REQD_FLAG,
                         CET.CALLBACK_EVENT_ID,
                         CET.CALLBACK_TIMESTAMP,
                         CET.REGISTERED_TIMESTAMP,
                         CET.WI_INSTANCE_ID,
                         CET.FA_INSTANCE_ID
                  FROM   XNP_CALLBACK_EVENTS CET,
                         XNP_MSG_TYPES_B L_MTE';