APPS.PA_SEARCH_GLOB dependencies on PA_FORECAST_ITEMS

Line 82: FROM PA_FORECAST_ITEMS res,

78: asgmt.item_quantity-1),1, 1,
79: greatest((nvl(res.capacity_quantity, 0) -
80: nvl(res.confirmed_qty, 0)), 0)/ asgmt.item_quantity))/
81: l_assignment_days * 100)
82: FROM PA_FORECAST_ITEMS res,
83: PA_FORECAST_ITEMS asgmt
84: WHERE res.resource_id = p_resource_id
85: AND res.forecast_item_type = 'U'
86: AND res.delete_flag = 'N'

Line 83: PA_FORECAST_ITEMS asgmt

79: greatest((nvl(res.capacity_quantity, 0) -
80: nvl(res.confirmed_qty, 0)), 0)/ asgmt.item_quantity))/
81: l_assignment_days * 100)
82: FROM PA_FORECAST_ITEMS res,
83: PA_FORECAST_ITEMS asgmt
84: WHERE res.resource_id = p_resource_id
85: AND res.forecast_item_type = 'U'
86: AND res.delete_flag = 'N'
87: AND res.item_date = asgmt.item_date

Line 97: --need to know the number of assignment days because the pa_forecast_items

93: GROUP BY res.person_id;
94:
95: BEGIN
96:
97: --need to know the number of assignment days because the pa_forecast_items
98: --table does not store unassigned time resource records with 0 hours.
99: --This will be used in the following sql statement...
100: SELECT count(*) INTO l_assignment_days
101: FROM pa_forecast_items

Line 101: FROM pa_forecast_items

97: --need to know the number of assignment days because the pa_forecast_items
98: --table does not store unassigned time resource records with 0 hours.
99: --This will be used in the following sql statement...
100: SELECT count(*) INTO l_assignment_days
101: FROM pa_forecast_items
102: WHERE assignment_id = p_assignment_id
103: AND delete_flag = 'N'
104: AND error_flag IN ('Y','N')
105: AND item_date >= trunc(SYSDATE)