The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT a.period_type
FROM pa_alloc_rules_all a,
gl_auto_alloc_batches b
WHERE b.allocation_set_id = p_allocation_set_id
AND b.batch_type_code = 'P'
AND a.rule_id = b.batch_id;
select period_type, org_id -- Fix for bug : 4640479
into v_period_type , l_org_id
from pa_alloc_rules_all
where rule_id = p_rule_id;
Select Status_Code
From GL_AUTO_ALLOC_BATCH_HISTORY
Where REQUEST_ID = p_request_Id
AND STEP_NUMBER = p_step_number;
Select
Meaning
,Description
From gl_lookups
Where LOOKUP_TYPE = 'AUTOALLOCATION_STATUS'
And LOOKUP_CODE = v_lookup_code;
Select request_id
From GL_AUTO_ALLOC_BAT_HIST_DET
Where PARENT_REQUEST_ID = p_request_Id
And STEP_NUMBER = p_step_number
order by request_id desc;