APPS.CSTPUPDT dependencies on CST_STD_COST_ADJ_VALUES

Line 316: DELETE FROM cst_std_cost_adj_values V

312:
313: return_code number;
314:
315: BEGIN
316: DELETE FROM cst_std_cost_adj_values V
317: WHERE v.cost_update_id = l_cost_update_id
318: AND v.transaction_type = 7 -- resource overhead
319: AND (V.old_unit_cost = 0 OR V.new_unit_cost = 0)
320: AND EXISTS

Line 322: FROM CST_STD_COST_ADJ_VALUES v1

318: AND v.transaction_type = 7 -- resource overhead
319: AND (V.old_unit_cost = 0 OR V.new_unit_cost = 0)
320: AND EXISTS
321: (SELECT 'X'
322: FROM CST_STD_COST_ADJ_VALUES v1
323: WHERE v1.cost_update_id = l_cost_update_id
324: AND v1.transaction_type = 7
325: AND v1.organization_id = v.organization_id
326: AND v1.wip_entity_id = v.wip_entity_id

Line 367: FROM CST_STD_COST_ADJ_VALUES

363:
364: CURSOR del_cur4 IS
365: SELECT organization_id, wip_entity_id,
366: operation_seq_num, resource_seq_num
367: FROM CST_STD_COST_ADJ_VALUES
368: WHERE cost_update_id = l_cost_update_id
369: AND transaction_type + 0 = 7;
370:
371: BEGIN

Line 373: DELETE CST_STD_COST_ADJ_VALUES

369: AND transaction_type + 0 = 7;
370:
371: BEGIN
372: FOR del_c2_cur IN del_cur4 LOOP
373: DELETE CST_STD_COST_ADJ_VALUES
374: WHERE cost_update_id = l_cost_update_id
375: AND new_unit_cost = old_unit_cost
376: AND transaction_type = 6
377: AND organization_id + 0 = del_c2_cur.organization_id

Line 403: DELETE cst_std_cost_adj_values V

399:
400: return_code number;
401:
402: BEGIN
403: DELETE cst_std_cost_adj_values V
404: WHERE V.rowid in
405: (SELECT VV1.rowidtodel
406: FROM cst_std_cost_adj_tmp1_v VV1, cst_std_cost_adj_tmp2_v VV2
407: WHERE VV1.transaction_id = VV2.transaction_id