APPS.GML_ORAUDTR_XMLP_PKG SQL Statements

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

Line: 9

      SELECT
        ORGN_NAME
      INTO CP_ORGN_NAME
      FROM
        SY_ORGN_MST
      WHERE ORGN_CODE = P_DEFAULT_ORGN;

Line: 15

      SELECT
        USER_NAME
      INTO CP_DEFAULT_USER
      FROM
        FND_USER
      WHERE USER_ID = P_DEFAULT_USER;

Line: 87

    SELECT
      DECODE(P_SORT3
            ,'1'
            ,'OD.LAST_UPDATE_DATE'
            ,'2'
            ,'IC_ITEM_MST.ITEM_NO'
            ,'3'
            ,'OD.CREATED_BY'
            ,'4'
            ,'OP_CUST_MST.CUST_NO')
    INTO MSORT3
    FROM
      DUAL;

Line: 100

    SELECT
      DECODE(P_SORT4
            ,'1'
            ,'OD.LAST_UPDATE_DATE'
            ,'2'
            ,'IC_ITEM_MST.ITEM_NO'
            ,'3'
            ,'OD.CREATED_BY'
            ,'4'
            ,'OP_CUST_MST.CUST_NO')
    INTO MSORT4
    FROM
      DUAL;

Line: 119

    SELECT
      DECODE(P_SORT3
            ,'1'
            ,'AD.LAST_UPDATE_DATE'
            ,'2'
            ,'IC_ITEM_MST.ITEM_NO'
            ,'3'
            ,'AD.CREATED_BY'
            ,'4'
            ,'OP_CUST_MST.CUST_NO')
    INTO DSORT3
    FROM
      DUAL;

Line: 132

    SELECT
      DECODE(P_SORT4
            ,'1'
            ,'AD.LAST_UPDATE_DATE'
            ,'2'
            ,'IC_ITEM_MST.ITEM_NO'
            ,'3'
            ,'AD.CREATED_BY'
            ,'4'
            ,'OP_CUST_MST.CUST_NO')
    INTO DSORT4
    FROM
      DUAL;

Line: 164

      SELECT
        DECIMAL_PRECISION
      INTO V_PRECISION
      FROM
        GL_CURR_MST
      WHERE CURRENCY_CODE = P_CUR;

Line: 195

    SELECT
      MEANING
    INTO CP_SORT_1
    FROM
      GEM_LOOKUP_VALUES
    WHERE LOOKUP_TYPE like 'GEMMS_OP_ORAUDTR'
      AND LOOKUP_CODE = P_SORT1;

Line: 202

    SELECT
      MEANING
    INTO CP_SORT_2
    FROM
      GEM_LOOKUP_VALUES
    WHERE LOOKUP_TYPE like 'GEMMS_OP_ORAUDTR'
      AND LOOKUP_CODE = P_SORT2;

Line: 210

      SELECT
        MEANING
      INTO CP_SORT_3
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORAUDTR'
        AND LOOKUP_CODE = P_SORT3;

Line: 219

      SELECT
        MEANING
      INTO CP_SORT_4
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORAUDTR'
        AND LOOKUP_CODE = P_SORT4;

Line: 244

    select decimal_precision into xx
           from gl_curr_mst
           where currency_code = billing_currency ;

Line: 271

    SELECT
      USER_NAME
    INTO V_USER_NAME
    FROM
      FND_USER
    WHERE USER_ID = CREATED_BY_1;

Line: 286

    SELECT
      USER_NAME
    INTO V_USER_NAME
    FROM
      FND_USER
    WHERE USER_ID = CREATED_BY2;