APPS.GMF_GMFLCDTL_XMLP_PKG SQL Statements

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

Line: 109

    SELECT
      BASE_CURRENCY_CODE
    INTO BCURR
    FROM
      GMF_FISCAL_POLICIES
    WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;

Line: 120

      SELECT
        BASE_CURRENCY_CODE
      FROM
        GMF_FISCAL_POLICIES
      WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;

Line: 154

      SELECT
        LEGAL_ENTITY_NAME
      INTO L_LEGAL_ENTITY_NAME
      FROM
        GMF_LEGAL_ENTITIES
      WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;

Line: 170

      SELECT
        COST_MTHD_CODE
      INTO L_COST_MTHD_CODE
      FROM
        CM_MTHD_MST
      WHERE COST_TYPE_ID = P_COST_TYPE_ID;