APPS.XTR_XTRAUSRM_XMLP_PKG SQL Statements

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

Line: 5

    SELECT
      SUBSTR(USER
            ,1
            ,10)
    INTO CP_PARA
    FROM
      DUAL;

Line: 18

      SELECT
        ITEM_NAME,
        TEXT LANG_NAME
      FROM
        XTR_SYS_LANGUAGES_VL
      WHERE MODULE_NAME = nvl(P_REPORT_NOS,'XTRAUSRM');

Line: 42

      ELSIF C.ITEM_NAME = 'Z1UPDATED_BY' THEN
        Z1UPDATED_BY := C.LANG_NAME;

Line: 56

      ELSIF C.ITEM_NAME = 'Z2UPDATED_BY' THEN
        Z2UPDATED_BY := C.LANG_NAME;

Line: 58

      ELSIF C.ITEM_NAME = 'Z2UPDATE_DATE_TIME' THEN
        Z2UPDATE_DATE_TIME := C.LANG_NAME;