The following lines contain the word 'select', 'insert', 'update' or 'delete':
select nvl( text, '')
from wf_Resources where name = 'WF_ADMIN_ROLE' --RLNAGARA B5654562 Changed from WF_ADMIN to WF_ADMIN_ROLE
and language = userenv('LANG') ;
select application_id into l_application_id
from fnd_application where application_short_name='GMD';
select user_name into l_user from fnd_user
where user_id=Approver.user_id;
/*select user_name into l_user from fnd_user a,per_all_people b
where
b.person_id=Approver.person_id and
a.employee_id is not null and
a.employee_id = b.person_id; */
-- Commented the above select statement and added new select to fix performance issues
select user_name into l_user from fnd_user a
where a.employee_id = Approver.person_id
and a.employee_id is not null
and exists (select 1 from per_all_people where person_id = Approver.person_id);
ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
transactionIdIn => l_event_key,
approverIn => Approver,
transactionTypeIn => l_transaction_type,
forwardeeIn => ame_util.emptyApproverRecord);