APPS.PA_FORECAST_ITEMS_UTILS dependencies on PA_FORECASTING_OPTIONS_ALL

Line 1211: -- Purpose To get the all forecast options from pa_forecasting_options_all table

1207:
1208:
1209: ----------------------------------------------------------------------------------------------------------------------
1210: -- Procedure Get_ForecastOptions
1211: -- Purpose To get the all forecast options from pa_forecasting_options_all table
1212: -- Input parameters
1213: -- Parameters Type Required Description
1214: -- p_org_id NUMBER YES Org id for which all the necessary information is needed
1215: -- Out parameters

Line 1283: FROM pa_forecasting_options_all

1279: x_bill_unassign_exp_type_class,x_bill_unassign_exp_type,
1280: x_nonbill_unassign_proj_id,x_nonbill_unassign_exp_typ_cls,
1281: x_nonbill_unassign_exp_type,x_default_tp_amount_type,
1282: x_util_cal_method
1283: FROM pa_forecasting_options_all
1284: WHERE org_id = p_org_id;
1285:
1286: /* Bug 2458198 -- Begin */
1287: IF (

Line 1656: FROM pa_forecasting_options_all

1652: SELECT default_assign_exp_type,
1653: default_assign_exp_type_class
1654: INTO x_default_assign_exp_type,
1655: x_default_assign_exp_type_cls
1656: FROM pa_forecasting_options_all
1657: WHERE org_id = x_org_id;
1658:
1659: exception
1660: WHEN NO_DATA_FOUND THEN