APPS.GMF_CMR11USR_XMLP_PKG SQL Statements

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

Line: 45

      SELECT
        '(' || BASE_CURRENCY_CODE || ')'
      INTO BCURR
      FROM
        GMF_FISCAL_POLICIES
      WHERE LEGAL_ENTITY_ID = LEGAL_ENTITY_ID1;

Line: 112

      SELECT
        CALENDAR_DESC
      INTO L_CALENDAR_DESC
      FROM
        CM_CLDR_HDR
      WHERE CALENDAR_CODE = COST_CALENDAR;

Line: 129

      SELECT
        PERIOD_DESC
      INTO L_PERIOD_DESC
      FROM
        CM_CLDR_DTL
      WHERE
      PERIOD_CODE = PERIOD_CODE1
      --PERIOD_CODE = PERIOD_CODE
        AND CALENDAR_CODE = COST_CALENDAR;