DBA Data[Home] [Help]

APPS.CSTPPPUR dependencies on CST_PAC_EAM_PERIOD_BALANCES

Line 164: UPDATE cst_pac_eam_period_balances

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

Line 172: DELETE FROM cst_pac_eam_period_balances

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