APPS.AP_CONC_PROG_PKG SQL Statements

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

Line: 33

        SELECT request_id
        FROM   ap_checkrun_conc_processes
        WHERE  checkrun_name = X_batch_name;

Line: 80

	-- Delete payment batch requests from table if all have finished
	--
	IF (X_tmp_flag = TRUE) THEN
	    X_debug_info := 'Delete requests from ap_checkrun_conc_processes';

Line: 85

	    DELETE FROM ap_checkrun_conc_processes
	    WHERE checkrun_name = X_batch_name;

Line: 133

	SELECT request_id
	FROM   fnd_concurrent_requests
	WHERE  program_application_id = X_application_id
	AND    concurrent_program_id = X_program_id;

Line: 145

	SELECT FCP.concurrent_program_id,
	       FCP.application_id
	INTO   X_program_id,
	       X_application_id
	FROM   fnd_concurrent_programs FCP, fnd_application FA
	WHERE  FA.application_short_name = X_application_name
	AND    FA.application_id = FCP.application_id
	AND    FCP.concurrent_program_name = X_program_name;

Line: 231

	SELECT execution_method_code
	INTO   X_execution_method
	FROM   fnd_concurrent_programs
	WHERE  application_id = 200
	AND    concurrent_program_name = X_program_name;

Line: 271

	SELECT srs_flag
	INTO   X_srs_flag
	FROM   fnd_concurrent_programs_vl
	WHERE  application_id = 200
	AND    concurrent_program_name = X_program_name;