APPS.CSTPPPUR dependencies on CST_PAC_EAM_ASSET_PER_BALANCES

Line 138: UPDATE cst_pac_eam_asset_per_balances

134: -- delete from cpeapb abd wepb where actual and estimate cols are 0
135:
136: l_stmt_num := 120;
137: -- Delete ceapb rows with zeros in ALL value columns
138: UPDATE cst_pac_eam_asset_per_balances
139: SET actual_mat_cost = 0,
140: actual_lab_cost = 0,
141: actual_eqp_cost = 0
142: WHERE legal_entity_id = i_legal_entity

Line 149: DELETE FROM cst_pac_eam_asset_per_balances

145: FROM cst_pac_periods
146: WHERE pac_period_id = i_pac_period_id);
147:
148: l_stmt_num := 130;
149: DELETE FROM cst_pac_eam_asset_per_balances
150: WHERE NVL(actual_mat_cost,0) = 0
151: AND NVL(actual_lab_cost,0) = 0
152: AND NVL(actual_eqp_cost,0) = 0
153: AND NVL(system_estimated_mat_cost,0) = 0