APPS.PA_FIN_PLAN_UTILS dependencies on PA_BUDGET_TYPES

Line 4030: l_budget_type_code pa_budget_types.budget_type_code%Type;

4026:
4027: --End of variables used for debugging
4028:
4029: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
4030: l_budget_type_code pa_budget_types.budget_type_code%Type;
4031: l_ac_budget_type_code pa_budget_types.budget_type_code%TYPE := 'AC'; --Bug 3764635.
4032:
4033: BEGIN
4034:

Line 4031: l_ac_budget_type_code pa_budget_types.budget_type_code%TYPE := 'AC'; --Bug 3764635.

4027: --End of variables used for debugging
4028:
4029: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
4030: l_budget_type_code pa_budget_types.budget_type_code%Type;
4031: l_ac_budget_type_code pa_budget_types.budget_type_code%TYPE := 'AC'; --Bug 3764635.
4032:
4033: BEGIN
4034:
4035: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4098: from pa_budget_types bud

4094: BEGIN
4095:
4096: select bud.budget_type_code
4097: into l_budget_type_code
4098: from pa_budget_types bud
4099: where bud.budget_type_code = l_ac_budget_type_code --Bug 3764635.
4100: and exists
4101: (
4102: select budget_version_id

Line 4212: l_budget_type_code pa_budget_types.budget_type_code%TYPE;

4208:
4209: --End of variables used for debugging
4210:
4211: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
4212: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
4213: l_ar_budget_type_code pa_budget_types.budget_type_code%TYPE := 'AR'; --Bug 3764635.
4214:
4215: BEGIN
4216:

Line 4213: l_ar_budget_type_code pa_budget_types.budget_type_code%TYPE := 'AR'; --Bug 3764635.

4209: --End of variables used for debugging
4210:
4211: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
4212: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
4213: l_ar_budget_type_code pa_budget_types.budget_type_code%TYPE := 'AR'; --Bug 3764635.
4214:
4215: BEGIN
4216:
4217: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4280: from pa_budget_types bud

4276: BEGIN
4277:
4278: select bud.budget_type_code
4279: into l_budget_type_code
4280: from pa_budget_types bud
4281: where bud.budget_type_code = l_ar_budget_type_code --Bug 3764635.
4282: and exists
4283: (
4284: select budget_version_id

Line 8347: FROM pa_budget_types

8343: SELECT DECODE(budget_amount_code, 'C', PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST,
8344: 'R', PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE,
8345: 'ALL', PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL)
8346: INTO x_version_type
8347: FROM pa_budget_types
8348: WHERE budget_type_code = p_budget_type_code;
8349: EXCEPTION
8350: WHEN NO_DATA_FOUND THEN
8351: IF p_pa_debug_mode = 'Y' THEN