APPS.GML_RIBOL_XMLP_PKG SQL Statements

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

Line: 29

    SELECT
      MEANING
    INTO TEMP
    FROM
      GEM_LOOKUP_VALUES
    WHERE LOOKUP_TYPE = 'GEMMS_OP_RIBOL'
      AND LOOKUP_CODE = P_SORT_ASC_DESC;

Line: 44

    SELECT
      ORGN_NAME
    INTO CP_ORGN_NAME
    FROM
      SY_ORGN_MST
    WHERE ORGN_CODE = P_DEFAULT_ORGN;

Line: 50

    SELECT
      USER_NAME
    INTO CP_USER
    FROM
      FND_USER
    WHERE USER_ID = P_DEFAULT_USER;