APPS.AR_RAXTTL_XMLP_PKG SQL Statements

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

Line: 9

      SELECT
        SUBSTRB(CP.USER_CONCURRENT_PROGRAM_NAME
               ,1
               ,80)
      INTO L_REPORT_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;

Line: 60

      SELECT
        SUBSTR(LC1.MEANING
              ,1
              ,16),
        SUBSTR(LC2.MEANING
              ,1
              ,16)
      INTO YES,NO
      FROM
        AR_LOOKUPS LC1,
        AR_LOOKUPS LC2
      WHERE LC1.LOOKUP_CODE = 'Y'
        AND LC1.LOOKUP_TYPE = 'YES/NO'
        AND LC2.LOOKUP_CODE = 'N'
        AND LC2.LOOKUP_TYPE = 'YES/NO';

Line: 88

      SELECT
        DECODE(INVOICE_TYPE_TYPE_ID
              ,NULL
              ,''
              ,SUBSTR(NAME
                    ,1
                    ,21))
      INTO INVOICE_TYPE
      FROM
        RA_CUST_TRX_TYPES
      WHERE CUST_TRX_TYPE_ID = INVOICE_TYPE_TYPE_ID
      OR ( INVOICE_TYPE_TYPE_ID is null
        AND ROWNUM < 2 );

Line: 111

      SELECT
        DECODE(CREDIT_MEMO_TYPEFORMULA.CREDIT_MEMO_TYPE_ID
              ,NULL
              ,''
              ,SUBSTR(NAME
                    ,1
                    ,27))
      INTO CREDIT_MEMO_TYPE
      FROM
        RA_CUST_TRX_TYPES
      WHERE CUST_TRX_TYPE_ID = CREDIT_MEMO_TYPEFORMULA.CREDIT_MEMO_TYPE_ID
      OR ( CREDIT_MEMO_TYPEFORMULA.CREDIT_MEMO_TYPE_ID is null AND ROWNUM < 2 );

Line: 133

      SELECT
        DECODE(TERM_ID
              ,NULL
              ,''
              ,SUBSTR(NAME
                    ,1
                    ,27))
      INTO TERM_NAME
      FROM
        RA_TERMS
      WHERE TERM_ID = TERM_NAMEFORMULA.TERM_ID
      OR ( TERM_ID is null
        AND ROWNUM < 2 );