APPS.PA_CC_TRANSFER_PRICE dependencies on PA_EXPENDITURE_TYPES

Line 3968: FROM PA_EXPENDITURE_TYPES

3964:
3965: IF p_raw_cost_rate(i) IS NULL THEN
3966: SELECT DECODE(nvl(COST_RATE_FLAG,'N'),'N',1,NULL)
3967: INTO l_raw_cost_rate
3968: FROM PA_EXPENDITURE_TYPES
3969: where EXPENDITURE_TYPE = p_expenditure_type(i);
3970: ELSE
3971: l_raw_cost_rate := p_raw_cost_rate(i);
3972: END IF;

Line 4721: C_EXPENDITURE_TYPE pa_expenditure_types.expenditure_type%TYPE,

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

Line 4732: Pa_expenditure_types Exp

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

Line 4930: l_cc_exp_category Pa_Expenditure_Types.EXPENDITURE_CATEGORY%TYPE;

4926: ERROR_OCCURED VARCHAR2(1);
4927:
4928: /* Get Transfer Price Parameters */
4929:
4930: l_cc_exp_category Pa_Expenditure_Types.EXPENDITURE_CATEGORY%TYPE;
4931:
4932: l_tp_asgid PA_PLSQL_DATATYPES.IdTabTyp;
4933: l_tp_exp_category PA_PLSQL_DATATYPES.Char30TabTyp;
4934: l_tp_labor_nl_flag PA_PLSQL_DATATYPES.Char1TabTyp;