APPS.PA_EXCEPTION_REASONS_PUB SQL Statements

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

Line: 26

		SELECT decode(x_return_type, 'R', exception_reason, corrective_action)
		  INTO ls_exception_text
		  FROM pa_exception_reasons
		 WHERE decode(x_exception_reason, null, x_exception_code, x_exception_reason) =
		       decode(x_exception_reason, null, exception_code, exception_reason)
		   AND x_exception_type = pa_exception_reasons.exception_category;

Line: 38

			SELECT decode(x_return_type, 'R', exception_reason, corrective_action)
			 INTO  ls_exception_text
			 FROM  pa_exception_reasons
			WHERE  exception_category = 'UNDEFINED'
			  AND  exception_code 	  = 'UNDEFINED';