[Home] [Help]
244: --Find the total estimated cost of workorder
245: BEGIN
246: SELECT NVL((SUM(system_estimated_mat_cost) + SUM(system_estimated_lab_cost) + SUM(system_estimated_eqp_cost)),0)
247: INTO l_cost_estimate
248: FROM WIP_EAM_PERIOD_BALANCES
249: WHERE wip_entity_id = p_eam_wo_rec.wip_entity_id;
250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN
252: l_cost_estimate := 0;
11911: --Find the total estimated cost of workorder
11912: BEGIN
11913: SELECT NVL((SUM(system_estimated_mat_cost) + SUM(system_estimated_lab_cost) + SUM(system_estimated_eqp_cost)),0)
11914: INTO l_cost_estimate
11915: FROM WIP_EAM_PERIOD_BALANCES
11916: WHERE wip_entity_id = l_eam_wo_comp_rec.wip_entity_id;
11917: EXCEPTION
11918: WHEN NO_DATA_FOUND THEN
11919: l_cost_estimate := 0;