APPS.IGS_GE_REPORT SQL Statements

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

Line: 38

	SELECT fcr.concurrent_program_id,
               fcr.parent_request_id,
               fr.description,
               fa.description,
               fcr.requested_start_date,
               TO_CHAR(fcr.RESUBMIT_INTERVAL)||' '||fcr.RESUBMIT_INTERVAL_UNIT_CODE,
               fcr.actual_start_date,
               fcr.printer,
               fcr.number_of_copies,
               fcr.save_output_flag
        FROM   FND_CONCURRENT_REQUESTS FCR,
               FND_APPLICATION_VL FA,
               FND_RESPONSIBILITY_VL FR
	WHERE  fcr.responsibility_id = fr.responsibility_id
	  AND  fcr.responsibility_application_id = fr.application_id  -- added by ssawhney 3690874
          AND  fcr.program_application_id = fa.application_id
          and  fcr.request_id = p_request_id;

Line: 57

		SELECT	parent_request_id,
                        request_type,
                        description
		FROM	fnd_concurrent_requests
		WHERE	request_id = cp_parent_id;