DBA Data[Home] [Help]

APPS.PA_SCHEDULE_UTILS dependencies on PA_FORECAST_ITEMS

Line 751: FROM pa_forecast_items

747:
748: BEGIN
749: SELECT sum(item_quantity)
750: INTO l_num_hours
751: FROM pa_forecast_items
752: WHERE assignment_id = p_assignment_id
753: AND delete_flag = 'N';
754:
755: l_num_hours := NVL(l_num_hours, 0);