APPS.PA_FIN_PLAN_MAINT_VER_GLOBAL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 146

select budget_version_id
  from pa_budget_versions
  where project_id = p_project_id and
	fin_plan_type_id = p_fin_plan_type_id and
	plan_processing_code = 'WUE' and
	process_update_wbs_flag = 'Y';

Line: 166

	select
	  fin_plan_preference_code,
	  margin_derived_from_code,
	  report_labor_hrs_from_code,
	  nvl(approved_rev_plan_type_flag, 'N')
	into
	  l_fin_plan_pref_code,
	  l_derive_margin_from_code,
	  l_report_labor_hrs_from_code,
	  x_ar_flag
	from
	  pa_proj_fp_options
	where
	  proj_fp_options_id=p_fin_plan_options_id;

Line: 199

	select
	  p.projfunc_currency_code,
	  p.project_currency_code,
	  NVL(pt.org_project_flag, 'N')
	into
	  l_currency_code,
	  l_proj_currency_code,
	  l_org_project_flag
	from
	  pa_projects_all p,
	  pa_project_types_all pt
	where
	  p.project_id=p_project_id and
	  p.project_type=pt.project_type and
	  p.org_id = pt.org_id; -- R12 MOAC 4447573: nvl(p.org_id, -99) = nvl(pt.org_id, -99)

Line: 224

	select
	  name
	into
	  l_fin_plan_type_name
	from
	  pa_fin_plan_types_tl
	where
	  fin_plan_type_id = p_fin_plan_type_id
          and language = USERENV('LANG');

Line: 242

     Code added to select plan_type_code so that Maintain
     Versions page can distinguish between ORG_FORECAST and
     non-ORG_FORECAST.
     Code added to select plan_class_code so that Maintain
     Versions page can set "Return to" link appropriately
     ================================================ */
        select fin_plan_type_code,
	       plan_class_code
          into l_fin_plan_type_code,
	       l_plan_class_code
          from pa_fin_plan_types_b
          where fin_plan_type_id = p_fin_plan_type_id;

Line: 322

    select version_name
      into l_version_name
      from pa_budget_versions
      where budget_version_id = px_target_version_id;

Line: 332

    update pa_budget_versions
      set version_name = l_version_name
      where budget_version_id = px_target_version_id;

Line: 384

    PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
	(p_project_id		=> p_project_id,
	 p_structure_version_id => l_structure_version_id,
	 x_return_status	=> l_return_status,
	 x_msg_count		=> l_msg_count,
	 x_msg_data		=> l_msg_data);