DBA Data[Home] [Help]

APPS.GMF_CMR12USR_XMLP_PKG SQL Statements

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

Line: 84

    SELECT
      BASE_CURRENCY_CODE
    INTO BCURR
    FROM
      GMF_FISCAL_POLICIES
    WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;
Line: 111

      SELECT
        PERIOD_ID,
        DECODE(PERIOD_STATUS
              ,'O'
              ,'Open'
              ,'F'
              ,'Frozen'
              ,'C'
              ,'Closed')
      INTO L_PERIOD_ID,L_PERIOD_STATUS
      FROM
        GMF_PERIOD_STATUSES
      WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
        AND CALENDAR_CODE = P_CALENDAR_CODE
        AND PERIOD_CODE = P_PERIOD_CODE
        AND COST_TYPE_ID = P_COST_TYPE_ID;
Line: 139

      SELECT
        COST_MTHD_CODE
      INTO L_COST_MTHD_CODE
      FROM
        CM_MTHD_MST
      WHERE COST_TYPE_ID = P_COST_TYPE_ID;