160: WHERE pac_period_id = i_pac_period_id);
161:
162: l_stmt_num := 140;
163: -- Delete cpepb rows with zeros in ALL value columns
164: UPDATE cst_pac_eam_period_balances
165: SET actual_mat_cost = 0,
166: actual_lab_cost = 0,
167: actual_eqp_cost = 0
168: WHERE cost_group_id = i_cost_group_id
168: WHERE cost_group_id = i_cost_group_id
169: AND pac_period_id = i_pac_period_id;
170:
171: l_stmt_num := 150;
172: DELETE FROM cst_pac_eam_period_balances
173: WHERE NVL(actual_mat_cost,0) = 0
174: AND NVL(actual_lab_cost,0) = 0
175: AND NVL(actual_eqp_cost,0) = 0
176: AND NVL(system_estimated_mat_cost,0) = 0