APPS.PA_CC_TRANSFER_PRICE dependencies on PA_EXPENDITURE_TYPES

Line 4064: FROM PA_EXPENDITURE_TYPES

4060:
4061: IF p_raw_cost_rate(i) IS NULL THEN
4062: SELECT DECODE(nvl(COST_RATE_FLAG,'N'),'N',1,NULL)
4063: INTO l_raw_cost_rate
4064: FROM PA_EXPENDITURE_TYPES
4065: where EXPENDITURE_TYPE = p_expenditure_type(i);
4066: ELSE
4067: l_raw_cost_rate := p_raw_cost_rate(i);
4068: END IF;

Line 4817: C_EXPENDITURE_TYPE pa_expenditure_types.expenditure_type%TYPE,

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
4821: SELECT

Line 4828: Pa_expenditure_types Exp

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
4832: AND PERIODS.ORG_ID = C_EXPENDITURE_ORG_ID

Line 5026: l_cc_exp_category Pa_Expenditure_Types.EXPENDITURE_CATEGORY%TYPE;

5022: ERROR_OCCURED VARCHAR2(1);
5023:
5024: /* Get Transfer Price Parameters */
5025:
5026: l_cc_exp_category Pa_Expenditure_Types.EXPENDITURE_CATEGORY%TYPE;
5027:
5028: l_tp_asgid PA_PLSQL_DATATYPES.IdTabTyp;
5029: l_tp_exp_category PA_PLSQL_DATATYPES.Char30TabTyp;
5030: l_tp_labor_nl_flag PA_PLSQL_DATATYPES.Char1TabTyp;