APPS.PA_ASSIGNMENT_UTILS dependencies on PA_FORECAST_ITEMS

Line 990: FROM pa_forecast_items

986: l_provisional_flag VARCHAR2(1);
987: BEGIN
988: SELECT sum(capacity_quantity)
989: INTO l_res_capacity_hrs
990: FROM pa_forecast_items
991: WHERE forecast_item_type = 'U'
992: AND delete_flag = 'N'
993: AND resource_id = p_resource_id
994: AND item_date BETWEEN p_asgn_start_date AND p_asgn_end_date;

Line 1003: FROM pa_forecast_items

999:
1000: IF (p_multiple_status_flag = 'Y') THEN
1001: SELECT sum(item_quantity)
1002: INTO g_provisional_hours
1003: FROM pa_forecast_items
1004: WHERE forecast_item_type = 'A'
1005: AND delete_flag = 'N'
1006: AND provisional_flag = 'Y'
1007: AND assignment_id = p_assignment_id;

Line 1011: FROM pa_forecast_items

1007: AND assignment_id = p_assignment_id;
1008: ELSE
1009: SELECT provisional_flag
1010: INTO l_provisional_flag
1011: FROM pa_forecast_items
1012: WHERE forecast_item_type = 'A'
1013: AND delete_flag = 'N'
1014: AND provisional_flag = 'Y'
1015: AND assignment_id = p_assignment_id