APPS.PA_REVENUE dependencies on PA_FORECAST_ITEMS

Line 148: l_item_quantity pa_forecast_items.item_quantity%TYPE; /* Added for bug 2212852 */

144: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
145:
146: l_revenue_calculated_flag VARCHAR2(1); /* Added for bug 2212852, if it is Y means it has calculated
147: the revenue from client extension */
148: l_item_quantity pa_forecast_items.item_quantity%TYPE; /* Added for bug 2212852 */
149: l_item_amount NUMBER; /* Added for bug 2212852 */
150: l_bill_rate_flag VARCHAR(1); /* Added for bug 2212852 */
151: l_status_client NUMBER; /* Added for bug 2212852 */
152: l_dummy_rate NUMBER; /* Added for bug 2212852 */

Line 204: FROM pa_forecast_items

200: l_revenue_calculated_flag := 'Y';
201: IF (p_forecasting_type = 'PROJECT_FORECASTING') THEN
202: SELECT item_quantity
203: INTO l_item_quantity
204: FROM pa_forecast_items
205: WHERE forecast_item_id = p_forecast_item_id;
206:
207: l_bill_rate := l_item_amount/l_item_quantity;
208:

Line 783: l_item_quantity pa_forecast_items.item_quantity%TYPE; /* Added for bug 2212852 */

779: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
780:
781: l_revenue_calculated_flag VARCHAR2(1); /* Added for bug 2212852, if it is Y means it has calculated
782: the revenue from client extension */
783: l_item_quantity pa_forecast_items.item_quantity%TYPE; /* Added for bug 2212852 */
784: l_item_amount NUMBER; /* Added for bug 2212852 */
785: l_bill_rate_flag VARCHAR2(1); /* Added for bug 2212852 */
786: l_status_client NUMBER; /* Added for bug 2212852 */
787: l_dummy_rate NUMBER; /* Added for bug 2212852 */

Line 907: FROM pa_forecast_items

903: l_revenue_calculated_flag := 'Y';
904: IF (p_forecasting_type = 'PROJECT_FORECASTING') THEN
905: SELECT item_quantity
906: INTO l_item_quantity
907: FROM pa_forecast_items
908: WHERE forecast_item_id = p_forecast_item_id;
909:
910: l_bill_rate := l_item_amount/l_item_quantity;
911: