DBA Data[Home] [Help]

APPS.PA_CC_TRANSFER_PRICE dependencies on PA_FORECASTING_OPTIONS

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

4716: AND FI.Error_Flag = 'N'
4717: AND FI.Delete_Flag = 'N'
4718: AND FI.Item_Date = c_start_date;
4719:
4720: Cursor FI_Attributes(C_PROJECT_ORG_ID pa_forecasting_options.ORG_ID%TYPE,
4721: C_EXPENDITURE_TYPE pa_expenditure_types.expenditure_type%TYPE,
4722: C_PVDR_PA_PERIOD_NAME Pa_periods_all.PERIOD_NAME%TYPE,
4723: C_EXPENDITURE_ORG_ID pa_forecasting_options.ORG_ID%TYPE)
4724: IS

Line 4723: C_EXPENDITURE_ORG_ID pa_forecasting_options.ORG_ID%TYPE)

4719:
4720: Cursor FI_Attributes(C_PROJECT_ORG_ID pa_forecasting_options.ORG_ID%TYPE,
4721: C_EXPENDITURE_TYPE pa_expenditure_types.expenditure_type%TYPE,
4722: C_PVDR_PA_PERIOD_NAME Pa_periods_all.PERIOD_NAME%TYPE,
4723: C_EXPENDITURE_ORG_ID pa_forecasting_options.ORG_ID%TYPE)
4724: IS
4725: SELECT
4726: FCST.JOB_COST_RATE_SCHEDULE_ID,
4727: EXP.Expenditure_CATEGORY,

Line 4731: Pa_forecasting_options_all Fcst,

4727: EXP.Expenditure_CATEGORY,
4728: PERIODS.End_Date
4729: FROM
4730: Pa_periods_all PERIODS,
4731: Pa_forecasting_options_all Fcst,
4732: Pa_expenditure_types Exp
4733: WHERE
4734: Exp.Expenditure_type = C_EXPENDITURE_TYPE
4735: AND PERIODS.PERIOD_NAME = C_PVDR_PA_PERIOD_NAME