APPS.PA_PPR_SMART_SLICE_PVT SQL Statements

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

Line: 77

       SELECT
         PROJ_ELEMENT_ID, project_id
       INTO
         l_struct_element_id, l_project_id
       FROM
         pa_proj_element_versions
       WHERE
         ELEMENT_VERSION_ID = p_wbs_version_id;

Line: 115

	    select fpo.rbs_version_id  , p.cbs_version_id
    into  l_new_rbs_version_id  , l_cbs_version_id
	from pa_budget_versions b  , pa_proj_fp_options  fpo, pa_projects_all p
	where b.budget_version_id =p_plan_version_id_tbl(i)
	AND b.fin_plan_type_id = fpo.fin_plan_type_id
     AND b.budget_version_id = fpo.fin_plan_version_id
	 AND b.project_id  = fpo.project_id
	 and b.project_id = p.project_id
    AND fpo.fin_plan_option_level_code = 'PLAN_VERSION'  ;