APPS.IEX_GAR_PUB SQL Statements

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

Line: 120

      SELECT  org_id INTO L_ORG_ID
      FROM fnd_concurrent_requests
      WHERE request_id=p_prev_request_id;

Line: 172

       select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;

Line: 198

        select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;

Line: 210

       SELECT count(*) INTO  l_acc_count FROM jtf_tae_1600_cust_winners;

Line: 370

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

Line: 380

        SELECT fnd_concurrent_requests_s.nextval into px_terr_globals.request_id from dual;

Line: 392

       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: 436

 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: 509

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

Line: 545

                SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;

Line: 573

	l_param_list.DELETE;