The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pt.enable_budget_wf_flag
FROM pa_projects p, pa_project_types pt
WHERE p.project_id = p_project_id
AND p.project_type = pt.project_type;
SELECT b.enable_wf_flag
FROM pa_budget_types b
WHERE b.budget_type_code = p_budget_type_code;
SELECT pl.enable_wf_flag
FROM pa_fin_plan_types_b pl
WHERE pl.fin_plan_type_id = p_fin_plan_type_id;
SELECT pm_project_reference
, segment1
, name
, description
, project_type
, pm_product_code
, carrying_out_organization_id
, template_flag --Bug 6691634
FROM pa_projects
WHERE project_id = p_project_id;
SELECT name
FROM hr_organization_units
WHERE organization_id = p_carrying_out_organization_id;
SELECT project_type_class_code
FROM pa_project_types
WHERE project_type = p_project_type;
SELECT user_name
FROM fnd_user
WHERE user_id = p_starter_user_id;
SELECT e.first_name||' '||e.last_name
FROM fnd_user f, per_all_people_f e
WHERE f.user_id = p_starter_user_id
AND f.employee_id = e.person_id
AND e.effective_start_date = (SELECT MIN(pap.effective_start_date) --Bug 5102146.
FROM per_all_people_f pap
WHERE pap.person_id = e.person_id
AND pap.effective_end_date >= TRUNC(SYSDATE));
SELECT pm_budget_reference
,description
,change_reason_code
,budget_entry_method_code
,pm_product_code
,labor_quantity
,raw_cost
,burdened_cost
,revenue
,resource_list_id
,version_name
,budget_type_code
,fin_plan_type_id
,version_type
FROM pa_budget_versions
WHERE budget_version_id = p_draft_version_id
AND budget_status_code = 'S';
SELECT name
, description
FROM pa_resource_lists
WHERE resource_list_id = p_resource_list_id;
SELECT budget_type
FROM pa_budget_types
WHERE budget_type_code = p_budget_type_code;
SELECT sysdate
FROM dual;
SELECT name, plan_class_code --Bug 6691634
FROM pa_fin_plan_types_vl fpt
WHERE fpt.fin_plan_type_id = l_fin_plan_type_id;
SELECT l1.meaning
, l2.meaning
FROM pa_proj_fp_options fo
, pa_lookups l1
, pa_lookups l2
WHERE fo.fin_plan_version_id = p_draft_version_id
AND l1.lookup_code = decode(l_version_type, 'COST', fo.cost_fin_plan_level_code
,'REVENUE', fo.revenue_fin_plan_level_code
,'ALL', fo.all_fin_plan_level_code, NULL)
AND l1.lookup_type = 'BUDGET ENTRY LEVEL'
AND l2.lookup_code = decode(l_version_type, 'COST', fo.cost_time_phased_code
,'REVENUE', fo.revenue_time_phased_code
,'ALL', fo.all_time_phased_code, NULL)
AND l2.lookup_type = 'BUDGET TIME PHASED TYPE';
SELECT budget_entry_method
FROM pa_budget_entry_methods m
WHERE m.budget_entry_method_code = l_budget_entry_method_code;
SELECT pa_workflow_itemkey_s.nextval
INTO itemkey
from dual;
PROCEDURE Select_Budget_Approver
(p_item_type IN VARCHAR2
, p_item_key IN VARCHAR2
, p_project_id IN NUMBER
, p_budget_type_code IN VARCHAR2
, p_workflow_started_by_id IN NUMBER
, p_fin_plan_type_id IN NUMBER default NULL
, p_version_type IN VARCHAR2 default NULL
, p_draft_version_id IN NUMBER default NULL
, p_budget_baseliner_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
)
--
IS
--
-- Define Your Local Variables Here
--
l_employee_id NUMBER;
SELECT employee_id
INTO l_employee_id
FROM fnd_user
WHERE user_id = p_workflow_started_by_id;
SELECT supervisor_id
INTO p_budget_baseliner_id
FROM per_assignments_f
WHERE person_id = l_employee_id
AND assignment_type in ('C','E') /* Bug#2911451 + FP.M for 'C' */
AND primary_flag = 'Y' /* Bug#2911451 */
AND TRUNC(sysdate) BETWEEN EFFECTIVE_START_DATE
AND NVL(EFFECTIVE_END_DATE, sysdate);
WF_CORE.CONTEXT('PA_CLIENT_EXTN_BUDGET_WF','SELECT_BUDGET_APPROVER',
p_item_type, p_item_key);
END Select_Budget_Approver;