APPS.PA_FIN_PLAN_MAINT_VER_GLOBAL dependencies on PA_PROJECT_TYPES_ALL

Line 107: -- 11/15/2002 - bug fix 2668857: when querying pa_project_types_all, need

103: end set_global_values;
104: /* ---------------------------------------------------------------- */
105:
106: -- HISTORY
107: -- 11/15/2002 - bug fix 2668857: when querying pa_project_types_all, need
108: -- to also use org_id to avoid returning multiple rows
109: procedure Maintain_Versions_Init
110: (p_project_id IN pa_projects_all.project_id%TYPE,
111: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,

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

111: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
112: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
113: x_fin_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
114: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
115: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
116: x_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE, --File.Sql.39 bug 4440895
117: x_proj_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
118: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
119: x_fin_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895

Line 135: l_org_project_flag pa_project_types_all.org_project_flag%TYPE;

131: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
132: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
133: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
134: l_derive_margin_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
135: l_org_project_flag pa_project_types_all.org_project_flag%TYPE;
136: l_currency_code pa_projects_all.projfunc_currency_code%TYPE;
137: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
138:
139: l_msg_count NUMBER := 0;

Line 208: pa_project_types_all pt

204: l_proj_currency_code,
205: l_org_project_flag
206: from
207: pa_projects_all p,
208: pa_project_types_all pt
209: where
210: p.project_id=p_project_id and
211: p.project_type=pt.project_type and
212: p.org_id = pt.org_id; -- R12 MOAC 4447573: nvl(p.org_id, -99) = nvl(pt.org_id, -99)