The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT INTO po_session_gt
( key,
num1
)
SELECT l_key,
l_index_tbl(i)
FROM DUAL
WHERE EXISTS (SELECT 1
FROM po_ga_org_assign_draft PGOAD
WHERE PGOAD.draft_id = p_draft_id_tbl(i)
AND PGOAD.org_assignment_id =
NVL(p_org_assignment_id_tbl(i),
PGOAD.org_assignment_id)
AND NVL(PGOAD.change_accepted_flag, 'Y') = 'Y');
DELETE FROM po_session_gt
WHERE key = l_key
RETURNING num1
BULK COLLECT INTO l_dft_exists_index_tbl;