The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_sel_clause := ' SELECT distinct pj.project_id, opt.fin_plan_type_id,'
||' opt.FIN_PLAN_PREFERENCE_CODE,pt.PLAN_CLASS_CODE'
||',pj.name';
SELECT min(pj.segment1)
INTO l_from_proj_no
FROM pa_projects pj /* Bug 5657334 */
WHERE NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed(pj.project_status_code),'N') <> 'Y';
SELECT max(pj.segment1)
INTO l_to_proj_no
FROM pa_projects pj /* Bug 5657334 */
WHERE NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed(pj.project_status_code),'N') <> 'Y';
l_element_type_tab.delete;
SELECT name INTO l_plan_type_name FROM pa_fin_plan_types_tl
WHERE
fin_plan_type_id = l_plan_type_id AND
language = USERENV('LANG');
SELECT count(*) INTO l_fin_plan_count
FROM pa_tasks
WHERE project_id = l_proj_id
AND gen_etc_source_code = lc_FinancialPlan
AND rownum < 2;
SELECT count(*) INTO l_workplan_count
FROM pa_tasks
WHERE project_id = l_proj_id
AND gen_etc_source_code = lc_WorkplanResources
AND rownum < 2;
select project_structure_version_id into l_etc_wp_struct_ver_id
from pa_budget_versions
where budget_version_id = l_etc_wp_fin_ver_id;
wp_fin_plan_ver_id to update back to pa_proj_fp_options*/
END IF; -- l_workplan_src_dtls_flag
SELECT version_name INTO l_etc_fp_ver_name
FROM pa_budget_versions
WHERE budget_version_id = l_etc_fp_ver_id;
/*update the etc source version id back to pa_proj_fp_options*/
IF l_element_type_tab(i) = 'COST' THEN
UPDATE PA_PROJ_FP_OPTIONS
SET GEN_SRC_COST_PLAN_TYPE_ID = l_etc_fp_type_id,
GEN_SRC_COST_PLAN_VERSION_ID = l_etc_fp_ver_id,
GEN_SRC_COST_WP_VERSION_ID = l_etc_wp_fin_ver_id
WHERE fin_plan_version_id = lx_budget_version_id;
UPDATE PA_PROJ_FP_OPTIONS
SET GEN_SRC_REV_PLAN_TYPE_ID = l_etc_fp_type_id,
GEN_SRC_REV_PLAN_VERSION_ID = l_etc_fp_ver_id,
GEN_SRC_REV_WP_VERSION_ID = l_etc_wp_fin_ver_id
WHERE fin_plan_version_id = lx_budget_version_id;
UPDATE PA_PROJ_FP_OPTIONS
SET GEN_SRC_ALL_PLAN_TYPE_ID = l_etc_fp_type_id,
GEN_SRC_ALL_PLAN_VERSION_ID = l_etc_fp_ver_id,
GEN_SRC_ALL_WP_VERSION_ID = l_etc_wp_fin_ver_id
WHERE fin_plan_version_id = lx_budget_version_id;