APPS.IEX_GAR_PUB SQL Statements

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

Line: 119

      SELECT  org_id INTO L_ORG_ID
      FROM fnd_concurrent_requests
      WHERE request_id=p_prev_request_id;

Line: 199

       SELECT count(*) INTO  l_acc_count FROM jtf_tae_1600_cust_winners;

Line: 358

    px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));

Line: 368

        SELECT fnd_concurrent_requests_s.nextval into px_terr_globals.request_id from dual;

Line: 380

       select REQUEST_ID into l_ata_request_id_of_failed_gar from jtf_tae_1001_account_trans
       where request_id is not null and rownum < 2 ;

Line: 424

 SELECT count(*)
 FROM   wf_events eve,
        wf_event_subscriptions sub
 WHERE  eve.name = p_event_name
 AND    eve.status = 'ENABLED'
 AND    eve.guid = sub.event_filter_guid
 AND    sub.status = 'ENABLED'
 AND    sub.source_type = 'LOCAL';

Line: 497

	SELECT count(*) into l_total_num_gar_workers
	FROM   fnd_concurrent_requests
	WHERE  parent_request_id = l_ata_request_id;

Line: 533

                SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;

Line: 561

	l_param_list.DELETE;