APPS.PA_FI_AMT_CALC_PKG dependencies on PA_FORECASTING_OPTIONS_ALL

Line 405: FROM Pa_Forecasting_Options_All fcst,

401: fcst.START_PERIOD_NAME START_PERIOD_NAME,
402: imp.Pa_Period_Type Pa_Period_Type,
403: sob.PERIOD_SET_NAME PERIOD_SET_NAME,
404: sob.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
405: FROM Pa_Forecasting_Options_All fcst,
406: Pa_Implementations_All imp,
407: Gl_Sets_Of_Books sob
408: WHERE /* Bug fix:4367847 NVL(imp.Org_Id,-99) = NVL(fcst.Org_Id,-99) AND */
409: imp.Org_Id = NVL(fcst.Org_Id,-99) AND

Line 478: l_fcst_cost_rate_schid pa_forecasting_options_All.JOB_COST_RATE_SCHEDULE_ID%TYPE;

474: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
475: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
476: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
477: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
478: l_fcst_cost_rate_schid pa_forecasting_options_All.JOB_COST_RATE_SCHEDULE_ID%TYPE;
479:
480: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
481: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
482: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

Line 1593: FROM PA_FORECASTING_OPTIONS_ALL

1589: l_prev_proj_orgid := l_fi_proj_orgid_tab(i);
1590: BEGIN
1591: SELECT JOB_COST_RATE_SCHEDULE_ID INTO
1592: l_fcst_cost_rate_schid
1593: FROM PA_FORECASTING_OPTIONS_ALL
1594: WHERE NVL(ORG_ID,-99) = l_prev_proj_orgid AND
1595: JOB_COST_RATE_SCHEDULE_ID IS NOT NULL;
1596: EXCEPTION
1597: WHEN NO_DATA_FOUND THEN