DBA Data[Home] [Help]

APPS.PA_CC_TRANSFER_PRICE dependencies on PA_FORECASTING_OPTIONS

Line 4816: Cursor FI_Attributes(C_PROJECT_ORG_ID pa_forecasting_options.ORG_ID%TYPE,

4812: AND FI.Error_Flag = 'N'
4813: AND FI.Delete_Flag = 'N'
4814: AND FI.Item_Date = c_start_date;
4815:
4816: Cursor FI_Attributes(C_PROJECT_ORG_ID pa_forecasting_options.ORG_ID%TYPE,
4817: C_EXPENDITURE_TYPE pa_expenditure_types.expenditure_type%TYPE,
4818: C_PVDR_PA_PERIOD_NAME Pa_periods_all.PERIOD_NAME%TYPE,
4819: C_EXPENDITURE_ORG_ID pa_forecasting_options.ORG_ID%TYPE)
4820: IS

Line 4819: C_EXPENDITURE_ORG_ID pa_forecasting_options.ORG_ID%TYPE)

4815:
4816: Cursor FI_Attributes(C_PROJECT_ORG_ID pa_forecasting_options.ORG_ID%TYPE,
4817: C_EXPENDITURE_TYPE pa_expenditure_types.expenditure_type%TYPE,
4818: C_PVDR_PA_PERIOD_NAME Pa_periods_all.PERIOD_NAME%TYPE,
4819: C_EXPENDITURE_ORG_ID pa_forecasting_options.ORG_ID%TYPE)
4820: IS
4821: SELECT
4822: FCST.JOB_COST_RATE_SCHEDULE_ID,
4823: EXP.Expenditure_CATEGORY,

Line 4827: Pa_forecasting_options_all Fcst,

4823: EXP.Expenditure_CATEGORY,
4824: PERIODS.End_Date
4825: FROM
4826: Pa_periods_all PERIODS,
4827: Pa_forecasting_options_all Fcst,
4828: Pa_expenditure_types Exp
4829: WHERE
4830: Exp.Expenditure_type = C_EXPENDITURE_TYPE
4831: AND PERIODS.PERIOD_NAME = C_PVDR_PA_PERIOD_NAME