APPS.PA_FIN_PLAN_CREATE_VER_GLOBAL SQL Statements

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

Line: 37

  select meaning
    into l_planning_level
    from pa_lookups
    where lookup_type = 'BUDGET ENTRY LEVEL' and
	  lookup_code = p_planning_level_code;

Line: 50

  select meaning
    into l_time_phase
    from pa_lookups
    where lookup_type = 'BUDGET TIME PHASED TYPE' and
	  lookup_code = p_time_phased_code;

Line: 63

  select name
    into l_resource_list_name
    from pa_resource_lists
    where resource_list_id = p_resource_list_id;

Line: 79

select period_name1
  from pa_proj_period_profiles
  where project_id = p_project_id and
	plan_period_type = 'GL' and
	current_flag = 'Y';

Line: 101

select profile_end_period_name
  from pa_proj_period_profiles
  where project_id = p_project_id and
	plan_period_type = 'GL' and
	current_flag = 'Y';

Line: 123

select period_name1
  from pa_proj_period_profiles
  where project_id = p_project_id and
	plan_period_type = 'PA' and
	current_flag = 'Y';

Line: 145

select profile_end_period_name
  from pa_proj_period_profiles
  where project_id = p_project_id and
	plan_period_type = 'PA' and
	current_flag = 'Y';

Line: 351

	select
	  nvl(pt.org_project_flag, 'N')
	into
	  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: 363

	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: 370

	select proj_fp_options_id,
	       fin_plan_preference_code,
	       DECODE(fin_plan_preference_code,
		      'COST_ONLY', nvl(approved_cost_plan_type_flag, 'N'),
		      'REVENUE_ONLY', nvl(approved_rev_plan_type_flag, 'N'),
		      DECODE(approved_cost_plan_type_flag,
			     'Y', 'Y',
			     nvl(approved_rev_plan_type_flag, 'N')))
	into l_proj_fp_options_id,
	     l_fin_plan_pref_code,
             l_approved_budget_flag
	from pa_proj_fp_options
	where project_id = p_project_id and
	      fin_plan_type_id = p_fin_plan_type_id and
	      fin_plan_option_level_code = 'PLAN_TYPE';