APPS.GMI_RIEDJL_XMLP_PKG SQL Statements

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

Line: 15

      SORTCP := 'orgn_code,doc_line,last_updated_by';

Line: 25

    SELECT
      USER_NAME
    INTO USERNAME
    FROM
      FND_USER
    WHERE USER_ID = GMI_RIEDJL_XMLP_PKG.USER_ID;

Line: 37

    SELECT
      ORGN_NAME
    INTO ORGNNAME
    FROM
      SY_ORGN_MST
    WHERE ORGN_CODE = P_ORGN;

Line: 54

  FUNCTION USERNAME_FORMULAFORMULA(LAST_UPDATED_BY1 IN NUMBER) RETURN VARCHAR2 IS
    UNAME VARCHAR2(100);

Line: 57

    SELECT
      USER_NAME
    INTO UNAME
    FROM
      FND_USER
    WHERE USER_ID = LAST_UPDATED_BY1;