The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT R.name
FROM pa_project_players P , wf_roles R
WHERE P.project_role_type = 'PROJECT MANAGER'
AND P.project_id = X_Project_ID
AND sysdate BETWEEN P.start_date_active AND nvl(P.end_date_active , sysdate + 1)
AND R.orig_system_id = P.person_id
AND R.orig_system = 'PER'
ORDER BY decode(R.name , X_Requestor , 0 , 1) , R.name;
SELECT 'Y'
FROM pjm_seiban_numbers
WHERE project_id = X_Project_ID;
SELECT p.organization_id
, mp.organization_code
, org.name organization_name
, p.from_project_id
, p.to_project_id
, p.transfer_date
, p.transfer_mode
, p.inventory_item_id
, p.category_set_id
, p.category_id
, r.reason_name transfer_reason
, p.transfer_reference
FROM pjm_mass_transfers p
, mtl_parameters mp
, hr_all_organization_units_tl org
, mtl_transaction_reasons r
WHERE p.mass_transfer_id = X_Transfer_ID
AND mp.organization_id = p.organization_id
AND org.organization_id = mp.organization_id
AND org.language = userenv('LANG')
AND r.reason_id (+) = p.transfer_reason_id
;
SELECT segment1 project_num , name project_name , description project_desc
FROM pa_projects_all
WHERE project_id = X_Project_ID
UNION ALL
SELECT project_number , project_name , project_name
FROM pjm_seiban_numbers
WHERE project_id = X_Project_ID;
SELECT concatenated_segments , description
FROM mtl_system_items_b_kfv
WHERE organization_id = X_Organization_ID
AND inventory_item_id = X_Item_ID
AND X_Transfer_Mode = PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_ONE_ITEM
UNION ALL
SELECT concatenated_segments , description
FROM mtl_categories_b_kfv
WHERE category_id = X_Category_ID
AND X_Transfer_Mode = PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_CATEGORY;
SELECT from_task_id
, to_task_id
FROM pjm_mass_transfer_tasks
WHERE mass_transfer_id = X_Transfer_ID;
SELECT task_number
, task_name
FROM pa_tasks
WHERE task_id = X_Task_ID;