APPS.GMD_SS_TEST_WF_PKG SQL Statements

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

Line: 54

	select NOTIFICATION_LEAD_TIME , NOTIFICATION_LEAD_TIME_UNIT,
		TESTING_GRACE_PERIOD , TESTING_GRACE_PERIOD_UNIT
	from gmd_stability_studies_b
	where ss_id = l_event_key ;

Line: 60

 select distinct time.time_point_id , time.scheduled_date, time.wf_sent, time.sampling_event_id
 from gmd_ss_time_points time ,
      gmd_ss_variants variant ,
      gmd_ss_material_sources sources,
      gmd_stability_studies ss
 where time.variant_id = variant.variant_id
  and sources.source_id = variant.material_source_id
  and variant.ss_id = l_event_key
  and ss.ss_id = variant.ss_id
  and nvl(variant.actual_end_date, sysdate+1) >= sysdate
  and nvl(ss.ACTUAL_END_DATE , sysdate+1) >= sysdate
  and variant.delete_mark = 0 ;

Line: 74

select disposition
from gmd_sampling_events
where sampling_event_id = se_id_in ;

Line: 92

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

Line: 237

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

Line: 251

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

Line: 254

         select user_name into l_user from fnd_user
          where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line: 266

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