APPS.GMI_RILSM_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      DECODE(FROM_STATUS
            ,NULL
            ,DECODE(TO_STATUS
                  ,NULL
                  ,'Status Range All'
                  ,' Status Range All - ' || TO_STATUS)
            ,DECODE(TO_STATUS
                  ,NULL
                  ,'Status Range ' || FROM_STATUS || ' - All '
                  ,'Status Range ' || FROM_STATUS || ' - ' || TO_STATUS))
    INTO RANGE_STATUS
    FROM
      DUAL;

Line: 26

    SELECT
      'Asc'
    INTO ORDER_CF
    FROM
      DUAL
    WHERE ORDER1 = 'Ascending';

Line: 43

    SELECT
      USER_NAME
    INTO USERNAME
    FROM
      FND_USER
    WHERE USER_ID = USER_ID_1;

Line: 55

      SELECT
        'All'
      INTO FROM_STATUSCP
      FROM
        DUAL;

Line: 69

      SELECT
        'All'
      INTO TO_STATUSCP
      FROM
        DUAL;

Line: 84

          select argument4 into order1  from FND_CONCURRENT_REQUESTS
where request_id =P_CONC_REQUEST_ID;