APPS.GMF_GMFINVAL_XMLP_PKG SQL Statements

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

Line: 6

      SELECT
        BASE_CURRENCY_CODE
      FROM
        GMF_FISCAL_POLICIES
      WHERE LEGAL_ENTITY_ID = CP_LEGAL_ENTITY_ID;

Line: 38

    select argument7 into P_CURRENT from FND_CONCURRENT_REQUESTS where request_id=P_CONC_REQUEST_ID;

Line: 91

      SELECT
        COST_ORGANIZATION_ID
      FROM
        CM_WHSE_ASC
      WHERE ORGANIZATION_ID = V_ORGANIZATION_ID
        AND EFF_START_DATE <= V_TRANS_DATE
        AND EFF_END_DATE >= V_TRANS_DATE
        AND DELETE_MARK = 0;

Line: 126

          SELECT
            PRIMARY_UNIT_OF_MEASURE
          INTO L_FROM_UOM
          FROM
            MTL_SYSTEM_ITEMS
          WHERE INVENTORY_ITEM_ID = UNITCOSTCFFORMULA.INVENTORY_ITEM_ID
            AND ORGANIZATION_ID = X_COST_ORGANIZATION_ID;

Line: 138

          SELECT
            PRIMARY_UNIT_OF_MEASURE
          INTO L_TO_UOM
          FROM
            MTL_SYSTEM_ITEMS
          WHERE INVENTORY_ITEM_ID = UNITCOSTCFFORMULA.INVENTORY_ITEM_ID
            AND ORGANIZATION_ID = UNITCOSTCFFORMULA.ORGANIZATION_ID;

Line: 163

		      /* temp_gmt_insert('L_UNIT_COST',' '||L_UNIT_COST);

Line: 164

		      temp_gmt_insert('P_EXCHANGE_RATE',' '||P_EXCHANGE_RATE);

Line: 165

		       temp_gmt_insert('UNITCOSTCP',' '||UNITCOSTCP);*/

Line: 187

      SELECT
        BASE_CURRENCY_CODE
      FROM
        GMF_FISCAL_POLICIES
      WHERE LEGAL_ENTITY_ID = CP_LEGAL_ENTITY_ID;

Line: 250

      SELECT
        LEGAL_ENTITY_NAME
      FROM
        GMF_LEGAL_ENTITIES
      WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;