The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_stage := 'SELECT ORG_ID FROM PA_IMPLEMENTATIONS';
SELECT org_id
INTO x_org_id
FROM pa_implementations;
x_stage := 'INSERT INTO PA_FUNCTION_TRANSACTIONS';
INSERT INTO pa_function_transactions(
application_id
, function_code
, function_transaction_code
, function_transaction_name
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, enabled_flag
, description
, org_id )
SELECT
ft.application_id
, ft.function_code
, ft.function_transaction_code
, ft.function_transaction_name
, sysdate
, x_user
, sysdate
, x_user
, x_login
, ft.enabled_flag
, ft.description
, x_org_id
FROM pa_function_transactions_all ft
WHERE org_id = -3113
AND NOT EXISTS (
SELECT NULL
FROM pa_function_transactions
WHERE org_id = x_org_id
AND application_id = ft.application_id
AND function_code = ft.function_code
AND function_transaction_code = ft.function_transaction_code );
x_stage := 'INSERT INTO PA_BILLING_ASSIGNMENTS';
INSERT INTO pa_billing_assignments(
billing_assignment_id
, billing_extension_id
, project_type
, project_id
, top_task_id
, amount
, percentage
, active_flag
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, distribution_rule
, org_id )
SELECT
pa_billing_assignments_s.NEXTVAL
, ba.billing_extension_id
, ba.project_type
, ba.project_id
, ba.top_task_id
, ba.amount
, ba.percentage
, ba.active_flag
, sysdate
, x_user
, sysdate
, x_user
, x_login
, ba.distribution_rule
, x_org_id
FROM pa_billing_assignments_all ba
WHERE org_id = -3113
AND NOT EXISTS (
SELECT NULL
FROM pa_billing_assignments
WHERE org_id = x_org_id
AND distribution_rule = ba.distribution_rule
AND billing_extension_id = ba.billing_extension_id
AND project_type = ba.project_type
AND project_id = ba.project_id
AND top_task_id = ba.top_task_id );