APPS.PA_GENERATE_FORECAST_PUB dependencies on PA_PERIODS

Line 305: PA_PERIODS_ALL P

301: MIN(FI.FORECAST_ITEM_ID)
302: FROM
303: PA_FORECAST_ITEMS FI,
304: PA_FORECAST_ITEM_DETAILS FID,
305: PA_PERIODS_ALL P
306: WHERE
307: FI.PROJECT_ORG_ID = NVL(P.ORG_ID,-99) AND
308: P.PERIOD_NAME = FI.RCVR_PA_PERIOD_NAME AND
309: FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID AND

Line 486: l_fcst_period_name PA_PERIODS.PERIOD_NAME%TYPE;

482: l_fcst_res_list PA_RESOURCE_LISTS_ALL_BG.RESOURCE_LIST_ID%TYPE;
483: l_fcst_period_type VARCHAR2(30);
484:
485: l_fcst_exp_org_id PA_FORECAST_ITEMS.EXPENDITURE_ORGANIZATION_ID%TYPE;
486: l_fcst_period_name PA_PERIODS.PERIOD_NAME%TYPE;
487: l_fcst_start_date PA_PERIODS.START_DATE%TYPE;
488: l_fcst_end_date PA_PERIODS.END_DATE%TYPE;
489: l_fcst_item_quantity PA_FORECAST_ITEMS.ITEM_QUANTITY%TYPE;
490: l_role_error_code PA_RESOURCE_ASSIGNMENTS.PLAN_ERROR_CODE%TYPE;

Line 487: l_fcst_start_date PA_PERIODS.START_DATE%TYPE;

483: l_fcst_period_type VARCHAR2(30);
484:
485: l_fcst_exp_org_id PA_FORECAST_ITEMS.EXPENDITURE_ORGANIZATION_ID%TYPE;
486: l_fcst_period_name PA_PERIODS.PERIOD_NAME%TYPE;
487: l_fcst_start_date PA_PERIODS.START_DATE%TYPE;
488: l_fcst_end_date PA_PERIODS.END_DATE%TYPE;
489: l_fcst_item_quantity PA_FORECAST_ITEMS.ITEM_QUANTITY%TYPE;
490: l_role_error_code PA_RESOURCE_ASSIGNMENTS.PLAN_ERROR_CODE%TYPE;
491:

Line 488: l_fcst_end_date PA_PERIODS.END_DATE%TYPE;

484:
485: l_fcst_exp_org_id PA_FORECAST_ITEMS.EXPENDITURE_ORGANIZATION_ID%TYPE;
486: l_fcst_period_name PA_PERIODS.PERIOD_NAME%TYPE;
487: l_fcst_start_date PA_PERIODS.START_DATE%TYPE;
488: l_fcst_end_date PA_PERIODS.END_DATE%TYPE;
489: l_fcst_item_quantity PA_FORECAST_ITEMS.ITEM_QUANTITY%TYPE;
490: l_role_error_code PA_RESOURCE_ASSIGNMENTS.PLAN_ERROR_CODE%TYPE;
491:
492: l_err_code VARCHAR2(30);