APPS.GMF_FND_GET_ORGANIZATION SQL Statements

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

Line: 6

  SELECT OU.ORGANIZATION_ID,
         OU.NAME,
         OU.DATE_FROM,
         OU.DATE_TO,
         null as OL_NAME,
         null as OL_DATE_FROM,
         null as OL_DATE_TO,
         0,
         SOB.ledger_id,
         SOB.CURRENCY_CODE,
         SOB.CHART_OF_ACCOUNTS_ID,
         SOB.NAME,
         SOB.PERIOD_SET_NAME,
         SOB.SUSPENSE_ALLOWED_FLAG,
         null as ALLOW_POSTING_WARNING_FLAG,
         SOB.ACCOUNTED_PERIOD_TYPE,
         SOB.SHORT_NAME,
         SOB.REQUIRE_BUDGET_JOURNALS_FLAG,
         SOB.ENABLE_BUDGETARY_CONTROL_FLAG,
         SOB.ALLOW_INTERCOMPANY_POST_FLAG,
         SOB.LAST_UPDATE_LOGIN,
         SOB.LATEST_ENCUMBRANCE_YEAR,
         null as EARLIEST_UNTRANS_PERIOD_NAME,
         SOB.CUM_TRANS_CODE_COMBINATION_ID,
         SOB.FUTURE_ENTERABLE_PERIODS_LIMIT,
         SOB.LATEST_OPENED_PERIOD_NAME,
         SOB.RET_EARN_CODE_COMBINATION_ID,
         SOB.RES_ENCUMB_CODE_COMBINATION_ID,
         SOB.DESCRIPTION,
         SOB.CREATED_BY,
         SOB.CREATION_DATE,
         SOB.LAST_UPDATE_DATE,
         SOB.LAST_UPDATED_BY
  FROM   HR_OPERATING_UNITS OU,
         gl_ledgers SOB
  WHERE  OU.set_of_books_id = sob.ledger_id
  AND    OU.ORGANIZATION_ID = NVL(PORG_ID, OU.ORGANIZATION_ID)
  AND    OU.NAME            = NVL(PORG_NAME, OU.NAME)
  AND    SOB.NAME           = NVL(PSOB_NAME, SOB.NAME);

Line: 67

               LAST_UPDATE_LOGIN              OUT    NOCOPY VARCHAR2,
               LATEST_ENCUMBRANCE_YEAR        OUT    NOCOPY VARCHAR2,
               EARLIEST_UNTRANS_PERIOD_NAME   OUT    NOCOPY VARCHAR2,
               CUM_TRANS_CODE_COMBINATION_ID  OUT    NOCOPY VARCHAR2,
               FUTURE_ENTERABLE_PERIODS_LIMIT OUT    NOCOPY VARCHAR2,
               LATEST_OPENED_PERIOD_NAME      OUT    NOCOPY VARCHAR2,
               RET_EARN_CODE_COMBINATION_ID   OUT    NOCOPY VARCHAR2,
               RES_ENCUMB_CODE_COMBINATION_ID OUT    NOCOPY VARCHAR2,
               DESCRIPTION                    OUT    NOCOPY VARCHAR2,
               CREATED_BY                     OUT    NOCOPY VARCHAR2,
               CREATION_DATE                  OUT    NOCOPY DATE,
               LAST_UPDATE_DATE               OUT    NOCOPY DATE,
               LAST_UPDATED_BY                OUT    NOCOPY VARCHAR2,
               ROW_TO_FETCH                   IN OUT NOCOPY NUMBER,
               ERROR_STATUS                   OUT    NOCOPY NUMBER)   IS

    CREATEDBY   NUMBER;

Line: 102

               LAST_UPDATE_LOGIN,              LATEST_ENCUMBRANCE_YEAR,
               EARLIEST_UNTRANS_PERIOD_NAME,   CUM_TRANS_CODE_COMBINATION_ID,
               FUTURE_ENTERABLE_PERIODS_LIMIT, LATEST_OPENED_PERIOD_NAME,
               RET_EARN_CODE_COMBINATION_ID,   RES_ENCUMB_CODE_COMBINATION_ID,
               DESCRIPTION,                    CREATEDBY,
               CREATION_DATE,                  LAST_UPDATE_DATE,
               MODIFIEDBY;

Line: 118

        LAST_UPDATED_BY := MODIFIEDBY;