APPS.FND_CONC_MAINTAIN SQL Statements

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

Line: 42

      SELECT r.application_id, r.responsibility_id
	INTO l_resp_appl_id, l_resp_id
	FROM fnd_application a, fnd_responsibility r
	WHERE r.application_id = a.application_id
	AND a.application_short_name = 'SYSADMIN'
	AND r.responsibility_key = 'SYSTEM_ADMINISTRATOR';

Line: 97

	SELECT request_id
	  INTO l_request_id
	  FROM fnd_concurrent_requests fcr,
	       fnd_concurrent_programs fcp,
	       fnd_application fa
	  WHERE fa.application_short_name = p_application_short_name
	  AND fcp.application_id = fa.application_id
	  AND fcp.concurrent_program_name = p_concurrent_program_name
	  AND fcr.program_application_id = fcp.application_id
	  AND fcr.concurrent_program_id  = fcp.concurrent_program_id
	  AND fcr.status_code in ('I', 'Q', 'R')
	  AND fcr.phase_code = 'P'
	  AND ROWNUM = 1;