DBA Data[Home] [Help]

APPS.EAM_COMPLETION dependencies on WIP_EAM_PERIOD_BALANCES

Line 1240: FROM WIP_EAM_PERIOD_BALANCES

1236: --Find the total estimated cost of workorder
1237: BEGIN
1238: SELECT NVL((SUM(system_estimated_mat_cost) + SUM(system_estimated_lab_cost) + SUM(system_estimated_eqp_cost)),0)
1239: INTO l_cost_estimate
1240: FROM WIP_EAM_PERIOD_BALANCES
1241: WHERE wip_entity_id =x_wip_entity_id;
1242: EXCEPTION
1243: WHEN NO_DATA_FOUND THEN
1244: l_cost_estimate := 0;