APPS.CSTPPPUR SQL Statements

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

Line: 44

    DELETE FROM cst_rcv_acq_cost_details cracd
    WHERE cracd.header_id in (SELECT  header_id FROM cst_rcv_acq_costs
                          WHERE   period_id     = i_pac_period_id
                            AND   cost_group_id = i_cost_group_id);

Line: 49

     DELETE FROM cst_rcv_acq_costs
     WHERE period_id     = i_pac_period_id
       AND cost_group_id = i_cost_group_id;

Line: 57

  DELETE FROM cst_pac_low_level_codes
  WHERE pac_period_id = i_pac_period_id
    AND cost_group_id = i_cost_group_id;

Line: 62

  DELETE /*+ index(cst_pac_explosion_temp CST_PAC_EXPLOSION_TEMP_N1) */
  FROM cst_pac_explosion_temp
  WHERE pac_period_id = i_pac_period_id
    AND cost_group_id = i_cost_group_id;

Line: 68

  DELETE FROM wip_pac_period_balances
  WHERE pac_period_id = i_pac_period_id
    AND cost_group_id = i_cost_group_id;

Line: 73

  DELETE FROM mtl_pac_txn_cost_details
  WHERE pac_period_id = i_pac_period_id
    AND cost_group_id = i_cost_group_id
    AND new_periodic_cost IS NULL
    AND value_change IS NULL
    AND percentage_change IS NULL;

Line: 81

  DELETE FROM mtl_pac_actual_cost_details
  WHERE pac_period_id = i_pac_period_id
    AND cost_group_id = i_cost_group_id;

Line: 86

  DELETE FROM wip_pac_actual_cost_details
  WHERE pac_period_id = i_pac_period_id
    AND cost_group_id = i_cost_group_id;

Line: 91

  DELETE FROM mtl_pac_cost_subelements
  WHERE pac_period_id = i_pac_period_id
    AND cost_group_id = i_cost_group_id;

Line: 99

  DELETE FROM cst_pac_req_oper_cost_details
  WHERE pac_period_id = i_pac_period_id
  AND   cost_group_id = i_cost_group_id;

Line: 105

  DELETE from cst_pac_quantity_layers
  WHERE  cost_layer_id in (SELECT cost_layer_id
                             FROM cst_pac_item_costs
                            WHERE pac_period_id = i_pac_period_id
                              AND cost_group_id = i_cost_group_id);

Line: 113

  DELETE FROM cst_pac_item_cost_details
   WHERE cost_layer_id in (SELECT cost_layer_id from cst_pac_item_costs
                            WHERE pac_period_id = i_pac_period_id
                              AND cost_group_id = i_cost_group_id);

Line: 119

  DELETE FROM cst_pac_item_costs
  WHERE pac_period_id = i_pac_period_id
    AND cost_group_id = i_cost_group_id;

Line: 128

  DELETE FROM cst_pac_period_balances
  WHERE  pac_period_id = i_pac_period_id
    AND  cost_group_id = i_cost_group_id;

Line: 138

  UPDATE cst_pac_eam_asset_per_balances
  SET    actual_mat_cost = 0,
         actual_lab_cost = 0,
         actual_eqp_cost = 0
  WHERE  legal_entity_id = i_legal_entity
  AND    cost_group_id = i_cost_group_id
  AND    cost_type_id = (SELECT cost_type_id
                         FROM   cst_pac_periods
                         WHERE  pac_period_id = i_pac_period_id);

Line: 149

  DELETE FROM cst_pac_eam_asset_per_balances
  WHERE  NVL(actual_mat_cost,0) = 0
  AND    NVL(actual_lab_cost,0) = 0
  AND    NVL(actual_eqp_cost,0) = 0
  AND    NVL(system_estimated_mat_cost,0) = 0
  AND    NVL(system_estimated_lab_cost,0) = 0
  AND    NVL(system_estimated_eqp_cost,0) = 0
  AND    legal_entity_id = i_legal_entity
  AND    cost_group_id = i_cost_group_id
  AND    cost_type_id = (SELECT cost_type_id
                         FROM   cst_pac_periods
                         WHERE  pac_period_id = i_pac_period_id);

Line: 164

  UPDATE cst_pac_eam_period_balances
  SET    actual_mat_cost = 0,
         actual_lab_cost = 0,
         actual_eqp_cost = 0
  WHERE  cost_group_id = i_cost_group_id
  AND    pac_period_id = i_pac_period_id;

Line: 172

  DELETE FROM cst_pac_eam_period_balances
  WHERE  NVL(actual_mat_cost,0) = 0
  AND    NVL(actual_lab_cost,0) = 0
  AND    NVL(actual_eqp_cost,0) = 0
  AND    NVL(system_estimated_mat_cost,0) = 0
  AND    NVL(system_estimated_lab_cost,0) = 0
  AND    NVL(system_estimated_eqp_cost,0) = 0
  AND    cost_group_id = i_cost_group_id
  AND    pac_period_id = i_pac_period_id;

Line: 218

  UPDATE cst_pac_process_phases cppp
  SET (cppp.process_status,cppp.last_update_date, cppp.process_upto_date) =
    (SELECT decode(cppp.process_phase,6,
              decode(NVL(clct.CREATE_ACCT_ENTRIES,'N'),'N',0,1),
              7,
              decode(NVL(clct.transfer_cost_flag,'N'),'N',0,1),
              8,
              decode(NVL(clct.transfer_cost_flag,'N'),'N',0,1),
              1),
            SYSDATE,
            NULL
    FROM cst_le_cost_types clct, cst_pac_periods cpp
    WHERE cpp.pac_period_id = i_pac_period_id
      AND clct.legal_entity = i_legal_entity
      AND clct.cost_type_id = cpp.cost_type_id)
  WHERE cppp.pac_period_id = i_pac_period_id
    AND cppp.cost_group_id = i_cost_group_id
    AND cppp.process_phase <> decode(i_acquisition_flag, 0, 1, 0);

Line: 275

  DELETE from cst_ae_lines
   where ae_header_id in
      (SELECT ae_header_id
         FROM cst_ae_headers
        WHERE period_id = i_pac_period_id
          AND cost_group_id = i_cost_group_id);

Line: 283

  DELETE FROM cst_encumbrance_lines
   WHERE ae_header_id in
     (SELECT ae_header_id
        FROM cst_ae_headers
       WHERE period_id = i_pac_period_id
         AND cost_group_id = i_cost_group_id);

Line: 291

  DELETE FROM cst_ae_headers
  WHERE period_id = i_pac_period_id
  AND cost_group_id = i_cost_group_id;

Line: 296

  DELETE FROM CST_PAC_ACCRUAL_RECONCILE_TEMP
  WHERE period_id = i_pac_period_id
  AND cost_group_id = i_cost_group_id;

Line: 301

  DELETE FROM CST_PAC_ACCRUAL_WRITE_OFFS
  WHERE period_id = i_pac_period_id
  AND cost_group_id = i_cost_group_id;