DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on WIP_EAM_PERIOD_BALANCES

Line 245: FROM WIP_EAM_PERIOD_BALANCES

241: --Find the total estimated cost of workorder
242: BEGIN
243: SELECT NVL((SUM(system_estimated_mat_cost) + SUM(system_estimated_lab_cost) + SUM(system_estimated_eqp_cost)),0)
244: INTO l_cost_estimate
245: FROM WIP_EAM_PERIOD_BALANCES
246: WHERE wip_entity_id = p_eam_wo_rec.wip_entity_id;
247: EXCEPTION
248: WHEN NO_DATA_FOUND THEN
249: l_cost_estimate := 0;

Line 11294: FROM WIP_EAM_PERIOD_BALANCES

11290: --Find the total estimated cost of workorder
11291: BEGIN
11292: SELECT NVL((SUM(system_estimated_mat_cost) + SUM(system_estimated_lab_cost) + SUM(system_estimated_eqp_cost)),0)
11293: INTO l_cost_estimate
11294: FROM WIP_EAM_PERIOD_BALANCES
11295: WHERE wip_entity_id = l_eam_wo_comp_rec.wip_entity_id;
11296: EXCEPTION
11297: WHEN NO_DATA_FOUND THEN
11298: l_cost_estimate := 0;