The following lines contain the word 'select', 'insert', 'update' or 'delete':
last_updated_by NUMBER(15); --|
last_update_login NUMBER(15); --|Standard Who Columns
SELECT event_type_classification
INTO classification
FROM pa_event_types
WHERE event_type = X2_event_type;
SELECT 'Valid Proj/Task/Assgn'
INTO dummy
FROM pa_tasks t, pa_projects p
WHERE t.project_id = X2_project_id
AND t.top_task_id = nvl(X2_top_task_id, t.top_task_id)
AND t.project_id = p.project_id
AND rownum = 1;
SELECT 'Valid Org'
INTO dummy
FROM hr_organization_units
WHERE organization_id = X2_organization_id;