APPS.GMD_QMDSC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

	     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')   ;

Line: 122

         select application_id into l_application_id
           from fnd_application where application_short_name='GMD';

Line: 135

         select user_name into l_user from fnd_user
           where user_id=Approver.user_id;

Line: 138

         /*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; */

Line: 145

	  -- 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);

Line: 160

          ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
                                       transactionIdIn => l_event_key,
                                       approverIn => Approver,
                                       transactionTypeIn => l_transaction_type,
                                       forwardeeIn => ame_util.emptyApproverRecord);