APPS.AS_GAR SQL Statements

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

Line: 53

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

Line: 61

        SELECT fnd_concurrent_requests_s.nextval into px_terr_globals.request_id from dual;

Line: 83

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

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

Line: 159

                SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;

Line: 184

	l_param_list.DELETE;

Line: 232

        select value into s from V$PARAMETER where name = 'sort_area_size';

Line: 240

        select value into s from V$PARAMETER where name = 'hash_area_size';