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 207: FROM pa_forecast_items

203: --Bug 7184968
204: BEGIN
205: SELECT item_quantity
206: INTO l_item_quantity
207: FROM pa_forecast_items
208: WHERE forecast_item_id = p_forecast_item_id;
209: EXCEPTION
210: WHEN NO_DATA_FOUND THEN
211: l_item_quantity := 0 ;

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

788: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
789:
790: l_revenue_calculated_flag VARCHAR2(1); /* Added for bug 2212852, if it is Y means it has calculated
791: the revenue from client extension */
792: l_item_quantity pa_forecast_items.item_quantity%TYPE; /* Added for bug 2212852 */
793: l_item_amount NUMBER; /* Added for bug 2212852 */
794: l_bill_rate_flag VARCHAR2(1); /* Added for bug 2212852 */
795: l_status_client NUMBER; /* Added for bug 2212852 */
796: l_dummy_rate NUMBER; /* Added for bug 2212852 */

Line 919: FROM pa_forecast_items

915: --Bug 7184968
916: BEGIN
917: SELECT item_quantity
918: INTO l_item_quantity
919: FROM pa_forecast_items
920: WHERE forecast_item_id = p_forecast_item_id;
921: EXCEPTION
922: WHEN NO_DATA_FOUND THEN
923: l_item_quantity := 0 ;