APPS.CSTPACIN SQL Statements

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

Line: 89

  SELECT MOD(SUM(DECODE(mp.process_enabled_flag,'Y',1,2)), 2)
    INTO l_pd_txfr_ind
    FROM mtl_parameters mp
   WHERE organization_id = i_txn_org_id
      OR organization_id = i_txfr_org_id;

Line: 115

    SELECT count(*)
    INTO l_avg_org
    FROM MTL_PARAMETERS
    WHERE ORGANIZATION_ID = i_txn_org_id
    AND PRIMARY_COST_METHOD = 2;

Line: 156

      SELECT count(*)
      INTO l_avg_org
      FROM MTL_PARAMETERS
      WHERE ORGANIZATION_ID = i_txfr_org_id
      AND PRIMARY_COST_METHOD = 2;

Line: 197

    SELECT count(*)
    INTO l_avg_org
    FROM MTL_PARAMETERS
    WHERE ORGANIZATION_ID = i_txn_org_id
    AND PRIMARY_COST_METHOD = 2;

Line: 254

    SELECT count(*)
    INTO l_avg_org
    FROM MTL_PARAMETERS
    WHERE ORGANIZATION_ID = i_txn_org_id
    AND PRIMARY_COST_METHOD = 2;

Line: 369

  SELECT
    transaction_date,
    transaction_source_id,
    source_code,
    encumbrance_amount
  INTO
    l_trx_info.TRANSACTION_DATE,
    l_txn_source_id,
    l_txn_source_code,
    l_encumbrance_amount
  FROM   MTL_MATERIAL_TRANSACTIONS
  WHERE  TRANSACTION_ID = i_txn_id;

Line: 402

      SELECT 'Y'
      INTO   l_std_txfr_flag
      FROM   MTL_PARAMETERS
      WHERE  ORGANIZATION_ID IN ( i_txn_org_id, i_txfr_org_id )
      AND    PRIMARY_COST_METHOD = 1;

Line: 446

    SELECT
      encumbrance_reversal_flag
    INTO
      l_enc_reversal_flag
    FROM
      MTL_PARAMETERS
    WHERE
      organization_id = i_txn_org_id;

Line: 511

     update EAM Elemental costs */
  if (i_citw_flag = 1) then
    select entity_type
    into l_entity_type
    from wip_entities
    where wip_entity_id = l_txn_source_id;