APPS.PA_FIN_PLAN_CREATE_VER_GLOBAL dependencies on PA_PROJECT_TYPES_ALL

Line 322: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895

318: ======================================================== */
319: procedure Create_Versions_Init
320: (p_project_id IN pa_projects_all.project_id%TYPE,
321: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
322: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
323: x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
324: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
325: x_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895
326: x_approved_budget_flag OUT NOCOPY pa_proj_fp_options.approved_cost_plan_type_flag%TYPE, --File.Sql.39 bug 4440895

Line 332: l_org_project_flag pa_project_types_all.org_project_flag%TYPE;

328: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
329: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
330: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
331:
332: l_org_project_flag pa_project_types_all.org_project_flag%TYPE;
333: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
334: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
335: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
336: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 357: pa_project_types_all pt

353: into
354: l_org_project_flag
355: from
356: pa_projects_all p,
357: pa_project_types_all pt
358: where
359: p.project_id=p_project_id and
360: p.project_type=pt.project_type and
361: p.org_id = pt.org_id; -- R12 MOAC 4447573: nvl(p.org_id,-99) = nvl(pt.org_id, -99)