APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_FIN_PLAN_TYPES_B

Line 146: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

142: x_prior_fcst_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
143: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
144: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
145: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
146: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
147: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
148: BEGIN
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150: select pt.plan_class_code,

Line 155: pa_fin_plan_types_b pt,

151: po.fin_plan_preference_code
152: into l_plan_class_code,
153: l_fin_plan_pref_code
154: from pa_budget_versions bv,
155: pa_fin_plan_types_b pt,
156: pa_proj_fp_options po
157: where bv.budget_version_id = p_budget_version_id and
158: bv.fin_plan_type_id = pt.fin_plan_type_id and
159: bv.budget_version_id = po.fin_plan_version_id;

Line 3319: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

3315: (p_plan_version_id IN pa_budget_versions.budget_version_id%TYPE,
3316: p_project_id IN pa_projects_all.project_id%TYPE
3317: ) return NUMBER
3318: is
3319: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
3320: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
3321: l_curr_fcst_ver_id pa_budget_versions.budget_version_id%TYPE := NULL;
3322: l_curr_fcst_ver_num pa_budget_versions.version_number%TYPE := NULL;
3323: l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE := NULL;

Line 3335: pa_fin_plan_types_b pt

3331: 'ALL','COST_AND_REV_SAME')
3332: into l_plan_class_code,
3333: l_fin_plan_pref_code
3334: from pa_budget_versions bv,
3335: pa_fin_plan_types_b pt
3336: where bv.budget_version_id = p_plan_version_id and
3337: bv.fin_plan_type_id = pt.fin_plan_type_id;
3338:
3339: if l_plan_class_code = 'BUDGET' then