APPS.XTR_XTRTMSTM_XMLP_PKG SQL Statements

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

Line: 11

      'SELECT DECODE(:REFERENCE,''INCRSE'',''Princ. Incr'',''Repayment'') INTO :REF_TYPE FROM DUAL';

Line: 13

    SELECT DECODE(REFERENCE,'INCRSE','Princ. Incr','Repayment') INTO REF_TYPE FROM DUAL;

Line: 25

      'SELECT DECODE(:REFERENCE,''DEDUCTION'',:ADJUST_PRINCIPAL,0) INTO :PRIN_DED FROM DUAL';

Line: 27

    SELECT DECODE(REFERENCE,'DEDUCTION',ADJUST_PRINCIPAL,0) INTO PRIN_DED FROM DUAL;

Line: 39

      'SELECT (nvl(:ADJUST_INTEREST,0) + nvl(:ADJUST_PRIN,0)) INTO :PI_RECD FROM DUAL';

Line: 41

    SELECT (nvl(ADJUST_INTEREST,0) + nvl(ADJUST_PRIN,0)) INTO PI_RECD FROM DUAL;

Line: 53

      'SELECT DECODE(:REFERENCE,''DEDUCTION'',:ADJUST_PRINCIPAL,:ADJUST_PRINCIPAL) INTO :ADJUST_PRIN FROM DUAL';

Line: 55

    SELECT DECODE(REFERENCE,'DEDUCTION',ADJUST_PRINCIPAL,ADJUST_PRINCIPAL) INTO ADJUST_PRIN FROM DUAL;

Line: 67

      'SELECT DECODE(:REFERENCE,''INCRSE'',:BALANCE_CFWD - NVL(:PRIN_DECRSE,0),:BALANCE_CFWD) INTO :ACTUAL_BAL FROM DUAL';

Line: 69

    SELECT DECODE(REFERENCE,'INCRSE',BALANCE_CFWD - NVL(PRIN_DECRSE,0),BALANCE_CFWD) INTO ACTUAL_BAL FROM DUAL;

Line: 86

      'SELECT nvl(:INTEREST_DUE,0) + nvl(:BALANCE_DUE,0) INTO :NET_DUE from DUAL';

Line: 88

    SELECT nvl(INTEREST_DUE,0) + nvl(BALANCE_DUE,0) INTO NET_DUE from DUAL;

Line: 106

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

Line: 121

      SELECT
        ITEM_NAME,
        SUBSTR(TEXT
              ,1
              ,100) LANG_NAME
      FROM
        XTR_SYS_LANGUAGES_VL
      WHERE MODULE_NAME = P_MODULE;

Line: 197

    SELECT
      CP.USER_CONCURRENT_PROGRAM_NAME
    INTO
      REPORT_SHORT_NAME
    FROM
      FND_CONCURRENT_PROGRAMS_VL CP,
      FND_CONCURRENT_REQUESTS CR
    WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
      AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
      AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;