APPS.PA_FIN_PLAN_MAINT_VER_GLOBAL dependencies on PA_FIN_PLAN_TYPES_TL

Line 113: x_fin_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895

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,
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

Line 129: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

125: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
126: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
127: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
128:
129: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
130: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%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;

Line 228: pa_fin_plan_types_tl

224: name
225: into
226: l_fin_plan_type_name
227: from
228: pa_fin_plan_types_tl
229: where
230: fin_plan_type_id = p_fin_plan_type_id
231: and language = USERENV('LANG');
232: