The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_last_updated_by Number;
l_last_update_login Number;
Select
ALLOCATION_SET_NAME
,ALLOCATION_SET_ID
,ALLOCATION_SET_TYPE_CODE
,ACCESS_SET_ID
,LEDGER_ID
,LEDGER_CURRENCY
,DESCRIPTION
,PERIOD_NAME
,BUDGET_VERSION_ID
,BALANCING_SEGMENT_VALUE
,JOURNAL_EFFECTIVE_DATE
,CALCULATION_EFFECTIVE_DATE
,USAGE_CODE
,GL_PERIOD_NAME
,PA_PERIOD_NAME
,EXPENDITURE_ITEM_DATE
,LAST_UPDATED_BY
,CREATED_BY
,LAST_UPDATE_LOGIN
From GL_AUTO_ALLOC_SET_HISTORY
Where REQUEST_ID = p_request_Id;
Select
STEP_NUMBER
, BATCH_ID
, BATCH_TYPE_CODE
, ALLOCATION_METHOD_CODE
, OWNER
From GL_AUTO_ALLOC_BATCH_HISTORY
Where REQUEST_ID = p_request_Id ;
,l_last_updated_by
,l_created_by
,l_last_update_login;
'Inserting into GL_AUTO_ALLOC_BAT_HIST_DET');
Insert Into GL_AUTO_ALLOC_BAT_HIST_DET (
REQUEST_ID
,PARENT_REQUEST_ID
,STEP_NUMBER
,PROGRAM_NAME_CODE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATION_DATE
,CREATED_BY
,STATUS_CODE
,RUN_MODE )
Values
( req_id
,p_request_Id
,l_step_number
,l_program_name_code
,sysdate
,l_last_updated_by
,l_last_update_login
,sysdate
,l_created_by
,NULL
,'P'
);